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, 259🔥, 0💬
Popular Posts:
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...