minte9
SoftwareDevelopment / 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






Questions and answers:
Clink on Option to Answer




1. Get date from Unixtime ...

  • a) SELECT {{FROM_UNIXTIME}}(1196440219);
  • b) SELECT {{DATE}}(1196440219);

2. Get date from Datetime ...

  • a) SELECT {{DATETIME}}('2003-12-31 01:02:03');
  • b) SELECT {{DATE}}('2003-12-31 01:02:03');


References: