Collections:
TO_SECONDS() - Converting Datetime to seconds
How to convert a datetime value into seconds since year 0 using the TO_SECONDS() function?
✍: FYIcenter.com
TO_SECONDS(datetime) is a MySQL built-in function that converts a datetime value into seconds since year 0. For example:
SELECT TO_SECONDS('1995-05-01'), TO_SECONDS(950501); -- +--------------------------+--------------------+ -- | TO_SECONDS('1995-05-01') | TO_SECONDS(950501) | -- +--------------------------+--------------------+ -- | 62966505600 | 62966505600 | -- +--------------------------+--------------------+ SELECT TO_SECONDS(NOW()), NOW(); -- +-------------------+---------------------+ -- | TO_SECONDS(NOW()) | NOW() | -- +-------------------+---------------------+ -- | 63867305526 | 2023-11-15 22:12:06 | -- +-------------------+---------------------+
Reference information of the TO_SECONDS() function:
TO_SECONDS(datetime): int Given a date or datetime expr, returns the number of seconds since the year 0. If expr is not a valid date or datetime value, returns NULL. Arguments, return value and availability: datetime: Required. The datetime value to be converted. int: Return value. The number of seconds since year 0. Available since MySQL 4.
Related MySQL functions:
⇒ UNIX_TIMESTAMP() - Calculating Unix Timestamp
⇐ TO_DAYS() - Converting Date to Days
2023-11-17, 250🔥, 0💬
Popular Posts:
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...
How To Connect the Oracle Server as SYSDBA in Oracle? This is Step 4. The best way to connect to the...