MySQL Functions on Date and Time

Q

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

A

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()

ADDTIME() - Adding Time

CONVERT_TZ() - Converting Time Zone

CURDATE() - Current Date

CURRENT_DATE() - Synonym for CURDATE()

CURRENT_TIME() - Synonym for CURTIME()

CURRENT_TIMESTAMP() - Synonym for NOW()

CURTIME() - Current Time

DATE() - Extracting Date

DATEDIFF() - Difference of Two Dates

DATE_ADD() - Adding Date/Time Interval

DATE_FORMAT() - Formatting Date

DATE_SUB() - Decrementing Date/Time

DAY() - Synonym for DAYOFMONTH()

DAYNAME() - Name of Weekday

DAYOFMONTH() - Day of Month

DAYOFWEEK() - Day of Week (1=Sunday)

DAYOFYEAR() - Day of Year

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

HOUR() - Hours of Time

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

MINUTE() - Minutes of Time

MONTH() - Month of Year

MONTHNAME() - Name of Month

NOW() - Start Time of Execution

PERIOD_ADD() - Adding Months to Period

PERIOD_DIFF() - Difference of Year-Month Periods

QUARTER() - Quarter of Year

SECOND() - Seconds of Time

SEC_TO_TIME() - Converting Seconds to Time

STR_TO_DATE() - Parsing String to Datetime

SUBDATE() - Synonym for DATE_SUB()

SUBTIME() - Subtracting Time

SYSDATE() - Current Timestamp

TIME() - Extracting Time

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_DATE() - Current UTC Date

UTC_TIME() - Current UTC Time

UTC_TIMESTAMP() - Current UTC Timestamp

WEEK() - Week of Year

WEEKDAY() - Weekday (0=Monday)

WEEKOFYEAR() - Calendar Week of Year

YEAR() - Year of Date

YEARWEEK() - Year Week Combination

⇒ ADDDATE() - Synonym for DATE_ADD()

⇐ TRUNCATE() - Truncating to Decimal Place

⇑⇑ MySQL Function References

2023-11-16, 1395🔥, 0💬

Calling MySQL Built-in Functions
Where to find answers to frequently asked questions about calling MySQL Built-in Functions? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com team about calling MySQL Built-in Functions: Function Name Case Insensitive Function Argument Modifier Variable Number ... 2023-11-14, 1576🔥, 0💬

IS_UUID() - Validating UUID String Format
How to validate a UUID (Universal Unique IDentifier) string using the IS_UUID() function? IS_UUID(uuid) is a MySQL built-in function that validates a UUID (Universal Unique IDentifier) string. It only checks if the given UUID is a 32-digit hexadecimal string or not. For example: SELECT IS_UUID('447f... 2023-12-08, 1552🔥, 0💬

VARIANCE() - Synonym for VAR_POP()
What's the difference between VARIANCE() and VAR_POP() functions? VARIANCE(expr) is a synonym for the VAR_POP(expr) function. Related MySQL functions: VAR_POP() - Population Standard Variance ⇒ Window Functions ⇐ VAR_SAMP() - Sample Standard Variance ⇑ MySQL Functions on Aggregation Groups ⇑⇑ My... 2023-12-01, 1361🔥, 0💬

SQRT() - Square Root of X
How to calculate the square root of a given number using the SQRT() function? SQRT(X) is a MySQL built-in function that calculates the square root of a given number. For example: SELECT SQRT(2), SQRT(4), SQRT(8); -- +--------------------+-------- -+--------------------+-- | SQRT(2) | SQRT(4) | SQRT(... 2023-11-14, 1342🔥, 0💬

VAR_SAMP() - Sample Standard Variance
How to calculate the sample standard variance of a field expression in result set groups using the VAR_SAMP() function? VAR_SAMP(expr) is a MySQL built-in aggregate function that calculates the sample standard variance of a field expression in result set groups. For example: SELECT help_category_id,... 2023-12-01, 1287🔥, 0💬

YEARWEEK() - Year Week Combination
How to calculate the year week combination from a given date using the YEARWEEK() function? YEARWEEK(date, mode) is a MySQL built-in function that calculates the year week combination from a given date. For example: SELECT YEARWEEK('2024-03-04'), WEEK('2024-03-04'); -- +------------------------+---- ... 2023-11-16, 1281🔥, 0💬

SUM() - Total Value in Group
How to calculate the total value of a field expression in result set groups using the SUM() function? SUM(expr) is a MySQL built-in aggregate function that calculates the total value of a field expression in result set groups. For example: SELECT help_category_id, SUM(help_topic_id), COUNT(help_topi... 2023-12-01, 1271🔥, 0💬

VAR_POP() - Population Standard Variance
How to calculate the population standard variance of a field expression in result set groups using the VAR_POP() function? VAR_POP(expr) is a MySQL built-in aggregate function that calculates the population standard variance of a field expression in result set groups. For example: SELECT help_catego... 2023-12-01, 1264🔥, 0💬

TRUNCATE() - Truncating to Decimal Place
How to truncate a value to a given decimal place using the TRUNCATE() function? TRUNCATE(X, D) is a MySQL built-in function that truncates X to decimal place of D. For example: SELECT TRUNCATE(-1.58, 0), TRUNCATE(23.298, 1), TRUNCATE(23.298, -1); -- +--------------------+-------- -------------+------... 2023-11-14, 1247🔥, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.