Date Time Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Date Time Functions
  4. 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>