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, 2329🔥, 0💬
Popular Posts:
How to calculate the storage size of a JSON (JavaScript Object Notation) value using the JSON_STORAG...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...
How to calculate the storage size of a JSON (JavaScript Object Notation) value using the JSON_STORAG...