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, 279🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...