UNIX_TIMESTAMP() returns a Unix timestamp (seconds since '1970-01-01 00:00:00' UTC) as an unsigned integer. : UNIX_TIMESTAMP « Date Time Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Date Time Functions
  3. UNIX_TIMESTAMP
mysql>
mysql> SELECT UNIX_TIMESTAMP();
+------------------+
| UNIX_TIMESTAMP() |
+------------------+
|       1185158783 |
+------------------+
1 row in set (0.00 sec)

mysql>








14.51.UNIX_TIMESTAMP
14.51.1.UNIX_TIMESTAMP() returns a Unix timestamp (seconds since '1970-01-01 00:00:00' UTC) as an unsigned integer.
14.51.2.UNIX_TIMESTAMP(date) returns the value of the argument as seconds since '1970-01-01 00:00:00' UTC
14.51.3.SELECT UNIX_TIMESTAMP('2005-03-27 03:00:00');