MySQL
keyboard_arrow_down 295 guides
chevron_leftDate and Time
Method ADDDATEMethod ADDTIMEMethod CONVERT_TZMethod CURDATEMethod CURRENT_DATEMethod CURRENT_TIMEMethod CURRENT_TIMESTAMPMethod CURTIMEMethod DATEMethod DATE_ADDMethod DATE_FORMATMethod DATE_SUBMethod DATEDIFFMethod DAYMethod DAYNAMEMethod DAYOFMONTHMethod DAYOFWEEKMethod DAYOFYEARMethod EXTRACTMethod FROM_DAYSMethod FROM_UNIXTIMEMethod GET_FORMATMethod HOURMethod LAST_DAYMethod LOCALTIMEMethod LOCALTIMESTAMPMethod MAKEDATEMethod MAKETIMEMethod MICROSECONDMethod MINUTEMethod MONTHMethod MONTHNAMEMethod NOWMethod PERIOD_ADDMethod PERIOD_DIFFMethod QUARTERMethod SEC_TO_TIMEMethod SECONDMethod STR_TO_DATEMethod SUBDATEMethod SUBTIMEMethod SYSDATEMethod TIMEMethod TIME_FORMATMethod TIME_TO_SECMethod TIMEDIFFMethod TIMESTAMPMethod TIMESTAMPADDMethod TIMESTAMPDIFFMethod TO_DAYSMethod TO_SECONDSMethod UNIX_TIMESTAMPMethod UTC_DATEMethod UTC_TIMEMethod UTC_TIMESTAMPMethod WEEKMethod WEEKDAYMethod WEEKOFYEARMethod YEARMethod YEARWEEK
check_circle
Mark as learned thumb_up
0
thumb_down
0
chat_bubble_outline
0
Comment auto_stories Bi-column layout
settings
MySQL | TO_DAYS method
schedule Aug 11, 2023
Last updated local_offer
Tags MySQL
tocTable of Contents
expand_more Master the mathematics behind data science with 100+ top-tier guides
Start your free 7-days trial now!
Start your free 7-days trial now!
MySQL's TO_DAYS(~) method returns the number of days since the start of the standard calendar (0000-00-00) from a provided date or datetime.
WARNING
This method should only be used with dates after the start of the Gregorian calendar (1582), as it does not account for lost days when the calendar was switched from Julian calendar.
Parameters
1. date | date|datetime
A date or datetime to convert to days since year 0.
Return value
The number of days since the start of the standard calendar (0000-00-00) for the input date or datetime.
Examples
To return days since year 0 for a datetime:
SELECT TO_DAYS('2020-04-16 09:30:20');
+--------------------------------+| TO_DAYS('2020-04-16 09:30:20') |+--------------------------------+| 737896 |+--------------------------------+
We now know that '2020-04-16 09:30:20' is equivalent to 737896 days since the start of year 0000-00-00.
Published by Arthur Yanagisawa
Edited by 0 others
Did you find this page useful?
thumb_up
thumb_down
Comment
Citation
Ask a question or leave a feedback...
Official MySQL Documentation
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_to-days
thumb_up
0
thumb_down
0
chat_bubble_outline
0
settings
Enjoy our search
Hit / to insta-search docs and recipes!
