Date Time Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Date Time Functions
  4. SELECT UNIX_TIMESTAMP(2005-03-27 03
mysql>
mysql> SELECT UNIX_TIMESTAMP('2005-03-27 03:00:00');
+---------------------------------------+
| UNIX_TIMESTAMP('2005-03-27 03:00:00') |
+---------------------------------------+
|                            1111917600 |
+---------------------------------------+
1 row in set (0.02 sec)
mysql>