Unixtime
Get formated date from a unixtime value.
SELECT <span class='keyword_code'>FROM_UNIXTIME</span>(1196440219);
-> 2007-11-30 18:30:19
Datetime
Extracts the date part of the date or datetime.
SELECT <span class='keyword_code'>DATE</span>('2003-12-31 01:02:03');
-> 2003-12-31
Last update: 222 days ago