UNIX_TIMESTAMP « Date Time Functions « MySQL Tutorial






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