Date Time Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Date Time Functions
  4. UNIX_TIMESTAMP(date) returns the value of the argument as seconds since 1970-01-01 00
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>