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, 1980🔥, 0💬
Popular Posts:
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
Where to find answers to frequently asked questions in general areas of Microsoft SQL Server Transac...