UNIX_TIMESTAMP(date) returns the value of the argument as seconds since '1970-01-01 00:00:00' UTC : UNIX_TIMESTAMP « Date Time Functions « MySQL Tutorial






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








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');