Twitter 
Facebook
chevron_left
Date 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
thumb_up
0
thumb_down
0
chat_bubble_outline
0
auto_stories new
settings
MySQL | TO_SECONDS method
Database
chevron_rightMySQL
chevron_rightDocumentation
chevron_rightFunctions
chevron_rightDate and Time
schedule Jul 1, 2022
Last updated local_offer MySQL
Tags tocTable of Contents
expand_more MySQL's TO_SECONDS(~) method returns the number of seconds from the start of the standard calendar (0000-00-00) from a provided date/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 seconds since year 0000-00-00.
Return value
The number of seconds from the start of the standard calendar (0000-00-00) for the input date/datetime.
Examples
To return seconds since year 0 for a datetime:
SELECT TO_SECONDS('2020-04-16 09:30:20');
+-----------------------------------+| TO_SECONDS('2020-04-16 09:30:20') |+-----------------------------------+| 63754248620 |+-----------------------------------+
Join our newsletter for updates on new DS/ML comprehensive guides (spam-free)
Published by Arthur Yanagisawa
Edited by 0 others
Did you find this page useful?
thumb_up
thumb_down
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-seconds
thumb_up
0
thumb_down
0
chat_bubble_outline
0
settings
Enjoy our search
Hit / to insta-search docs and recipes!
