{"id":2879,"date":"2018-07-04T17:54:58","date_gmt":"2018-07-05T00:54:58","guid":{"rendered":"https:\/\/database.guide\/?p=2879"},"modified":"2021-09-05T13:20:39","modified_gmt":"2021-09-05T03:20:39","slug":"to_seconds-examples-mysql","status":"publish","type":"post","link":"https:\/\/database.guide\/to_seconds-examples-mysql\/","title":{"rendered":"TO_SECONDS() Examples – MySQL"},"content":{"rendered":"

In MySQL<\/a>, the TO_SECONDS()<\/code> function returns the number of seconds since the year 0.<\/p>\n

This function is not to be confused with the TIME_TO_SECONDS()<\/code><\/a> function, which returns the number of seconds in a given time value provided as an argument.
\n<\/p>\n

Syntax<\/h2>\n

The syntax goes like this:<\/p>\n

TO_SECONDS(expr)\r\n<\/pre>\n
Where expr<\/code> is a date or datetime value (to be compared to year 0).<\/p>\n
Example 1 – Using a ‘date’ Argument<\/h2>\n
Here’s an example using a date argument.<\/p>\n
SELECT TO_SECONDS('2021-09-21');\r\n<\/pre>\n
Result:<\/p>\n
+--------------------------+\r\n| TO_SECONDS('2021-09-21') |\r\n+--------------------------+\r\n|              63799401600 |\r\n+--------------------------+\r\n<\/pre>\n
Example 2 – Using a ‘datetime’ Argument<\/h2>\n
Here’s an example using a datetime argument.<\/p>\n
SELECT TO_SECONDS('2021-09-21 10:30:25');\r\n<\/pre>\n
Result:<\/p>\n
+-----------------------------------+\r\n| TO_SECONDS('2021-09-21 10:30:25') |\r\n+-----------------------------------+\r\n|                       63799439425 |\r\n+-----------------------------------+\r\n<\/pre>\n
Example 3 – Using the Current Date<\/h2>\n
In this example, I pass the CURDATE()<\/code><\/a> function as the argument in order to use the current date.<\/p>\n
SELECT TO_SECONDS(CURDATE()) AS 'Result';\r\n<\/pre>\n
Result:<\/p>\n
+-------------+\r\n| Result      |\r\n+-------------+\r\n| 63697968000 |\r\n+-------------+\r\n<\/pre>\n
Example 4 – Using the Current Date and Time<\/h2>\n
In this example, I pass the NOW()<\/code><\/a> function as the argument in order to use the current date and time.<\/p>\n
SELECT TO_SECONDS(NOW()) AS 'Result';\r\n<\/pre>\n
Result:<\/p>\n
+-------------+\r\n| Result      |\r\n+-------------+\r\n| 63698002698 |\r\n+-------------+\r\n<\/pre>\n
Two-Digit Years<\/h2>\n
MySQL has special rules for dealing with dates with two-digit years. Two-digit years are ambiguous because the century is unknown. Basically, the following rules apply:<\/p>\n