minte9
LearnRemember   MYSQL





Unixtime

Get formated date from a unixtime value. 
 
SELECT FROM_UNIXTIME(1196440219);

        -> 2007-11-30 18:30:19

Datetime

Extracts the date part of the date or datetime. 
 
SELECT DATE('2003-12-31 01:02:03');

        -> 2003-12-31




References: