Collections:
TO_DAYS() - Converting Date to Days
How to convert a date value into days since year 0 using the TO_DAYS() function?
✍: FYIcenter.com
TO_DAYS(date) is a MySQL built-in function that converts a date value into days since year 0. For example:
SELECT TO_DAYS('1995-05-01'), TO_DAYS(950501); -- +-----------------------+-----------------+ -- | TO_DAYS('1995-05-01') | TO_DAYS(950501) | -- +-----------------------+-----------------+ -- | 728779 | 728779 | -- +-----------------------+-----------------+
Reference information of the TO_DAYS() function:
TO_DAYS(date): int Given a date date, returns a day number (the number of days since year 0). Arguments, return value and availability: date: Required. The date value to be converted. int: Return value. The number of days since year 0. Available since MySQL 4.
Related MySQL functions:
⇒ TO_SECONDS() - Converting Datetime to seconds
⇐ TIME_TO_SEC() - Converting Time to Seconds
2023-11-17, 271🔥, 0💬
Popular Posts:
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...