Mega Code Archive

 

Categories / MySQL Tutorial / Date Time Functions

 

UNIX_TIMESTAMP() returns a Unix timestamp (seconds since 1970-01-01 00

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