MySQL Tutorial/Date Time Functions/UNIX TIMESTAMP

SELECT UNIX_TIMESTAMP("2005-00:00");

   <source lang="sql">

mysql> mysql> SELECT UNIX_TIMESTAMP("2005-03-27 03:00:00"); +---------------------------------------+ | UNIX_TIMESTAMP("2005-03-27 03:00:00") | +---------------------------------------+ | 1111917600 | +---------------------------------------+ 1 row in set (0.02 sec) mysql></source>

UNIX_TIMESTAMP(date) returns the value of the argument as seconds since "1970-00:00" UTC

   <source lang="sql">

mysql> mysql> SELECT UNIX_TIMESTAMP("1997-10-04 22:23:00"); +---------------------------------------+ | UNIX_TIMESTAMP("1997-10-04 22:23:00") | +---------------------------------------+ | 876028980 | +---------------------------------------+ 1 row in set (0.00 sec) mysql></source>

UNIX_TIMESTAMP() returns a Unix timestamp (seconds since "1970-00:00" UTC) as an unsigned integer.

   <source lang="sql">

mysql> mysql> SELECT UNIX_TIMESTAMP(); +------------------+ | UNIX_TIMESTAMP() | +------------------+ | 1185158783 | +------------------+ 1 row in set (0.00 sec) mysql></source>