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
0
0
0
new
MySQL | TIME_TO_SEC method
Database
chevron_rightMySQL
chevron_rightDocumentation
chevron_rightFunctions
chevron_rightDate and Time
schedule Mar 10, 2022
Last updated MySQL
Tags tocTable of Contents
expand_more MySQL's TIME_SEC(~) method converts the provided time value to the equivalent number of seconds.
Parameters
1. time | time
The time value to be converted to number of seconds.
Return value
Number of seconds equivalent to the input time value.
Examples
To return the number of seconds equivalent to '23:59:59':
SELECT TIME_TO_SEC('23:59:59');
+-------------------------+| TIME_TO_SEC('23:59:59') |+-------------------------+| 86399 |+-------------------------+
We now know that '23:59:59' is equivalent to 86399 seconds.
Published by Arthur Yanagisawa
Edited by 0 others
Did you find this page useful?
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_time-to-sec
