Name
Calculating and Modifying the Date and Time
Synopsis
ADDDATE( )
, ADDTIME( )
,
CONVERT_TZ( )
, DATE_ADD( )
,
DATE_SUB( )
, DATEDIFF( )
,
FROM_DAYS( )
, FROM_UNIXTIME( )
,
PERIOD_ADD( )
, PERIOD_DIFF( )
,
SEC_TO_TIME( )
, SUBDATE( )
,
SUBTIME( )
, TIME_TO_SEC( )
,
TO_DAYS( )
, TIMEDIFF( )
,
TIMESTAMPADD( )
, TIMESTAMPDIFF()
Get MySQL in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.