Collections:
MySQL Functions on Date and Time
Where to find reference information and tutorials on MySQL database functions on Date and Time? I want to know how to use ADDDATE(), DATEDIFF() and other date and time value related functions.
✍: FYIcenter.com
Here is a collection of reference information and tutorials on MySQL database functions on Date and Time compiled by FYIcenter.com DBA team.
ADDDATE() - Synonym for DATE_ADD()
CONVERT_TZ() - Converting Time Zone
CURRENT_DATE() - Synonym for CURDATE()
CURRENT_TIME() - Synonym for CURTIME()
CURRENT_TIMESTAMP() - Synonym for NOW()
DATEDIFF() - Difference of Two Dates
DATE_ADD() - Adding Date/Time Interval
DATE_FORMAT() - Formatting Date
DATE_SUB() - Decrementing Date/Time
DAY() - Synonym for DAYOFMONTH()
DAYOFWEEK() - Day of Week (1=Sunday)
EXTRACT() - Extracting Datetime Component
FORMAT_PICO_TIME() - Formatting Picoseconds in Readable Units
FROM_DAYS() - Converting Days to Date
FROM_UNIXTIME() - Unix Time to Datetime
GET_FORMAT() - Standard Datetime Formats
LAST_DAY() - Last Day of Month
LOCALTIME() - Synonym for NOW()
LOCALTIMESTAMP() - Synonym for NOW()
MAKEDATE() - Making Date from Days
MAKETIME() - Making Time from Components
MICROSECOND() - Microseconds of Time
NOW() - Start Time of Execution
PERIOD_ADD() - Adding Months to Period
PERIOD_DIFF() - Difference of Year-Month Periods
SEC_TO_TIME() - Converting Seconds to Time
STR_TO_DATE() - Parsing String to Datetime
SUBDATE() - Synonym for DATE_SUB()
TIMEDIFF() - Difference of Two Timestamps
TIMESTAMP() - Adding Time to Timestamp
TIMESTAMPADD() - Incrementing Timestamp
TIMESTAMPDIFF() - Difference in Timestamp Component
TIME_FORMAT() - Formatting Time
TIME_TO_SEC() - Converting Time to Seconds
TO_DAYS() - Converting Date to Days
TO_SECONDS() - Converting Datetime to seconds
UNIX_TIMESTAMP() - Calculating Unix Timestamp
UTC_TIMESTAMP() - Current UTC Timestamp
WEEKDAY() - Weekday (0=Monday)
⇒ ADDDATE() - Synonym for DATE_ADD()
2023-11-16, 253🔥, 0💬
Popular Posts:
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...
How To Drop a Stored Procedure in Oracle? If there is an existing stored procedure and you don't wan...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...