Date
MySQL comes with the following data types for storing a date or a date/time value in the database:
DATE - format YYYY-MM-DD
DATETIME - format: YYYY-MM-DD HH:MI:SS
TIMESTAMP - format: YYYY-MM-DD HH:MI:SS
YEAR - format YYYY or YY
Date and Time Manipulation Functions
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html
Name | Description |
Add time values (intervals) to a date value | |
Add time | |
Convert from one time zone to another | |
Return the current date | |
Synonyms for CURDATE() | |
Synonyms for CURTIME() | |
Synonyms for NOW() | |
Return the current time | |
Extract the date part of a date or datetime expression | |
Add time values (intervals) to a date value | |
Format date as specified | |
Subtract a time value (interval) from a date | |
Subtract two dates | |
Synonym for DAYOFMONTH() | |
Return the name of the weekday | |
Return the day of the month (0-31) | |
Return the weekday index of the argument | |
Return the day of the year (1-366) | |
Extract part of a date | |
Convert a day number to a date | |
Format Unix timestamp as a date | |
Return a date format string | |
Extract the hour | |
Return the last day of the month for the argument | |
Synonym for NOW() | |
Synonym for NOW() | |
Create a date from the year and day of year | |
Create time from hour, minute, second | |
Return the microseconds from argument | |
Return the minute from the argument | |
Return the month from the date passed | |
Return the name of the month | |
Return the current date and time | |
Add a period to a year-month | |
Return the number of months between periods | |
Return the quarter from a date argument | |
Converts seconds to 'HH:MM:SS' format | |
Return the second (0-59) | |
Convert a string to a date | |
Synonym for DATE_SUB() when invoked with three arguments | |
Subtract times | |
Return the time at which the function executes | |
Extract the time portion of the expression passed | |
Format as time | |
Return the argument converted to seconds | |
Subtract time | |
With a single argument, this function returns the date or datetime expression; with two arguments, the sum of the arguments | |
Add an interval to a datetime expression | |
Subtract an interval from a datetime expression | |
Return the date argument converted to days | |
Return the date or datetime argument converted to seconds since Year 0 | |
Return a Unix timestamp | |
Return the current UTC date | |
Return the current UTC time | |
Return the current UTC date and time | |
Return the week number | |
Return the weekday index | |
Return the calendar week of the date (1-53) | |
Return the year | |
Return the year and week |
DATEDIFF()
returnsexpr1
−expr2
_expressed as a value in days from one date to the other.expr1
andexpr2
_are date or date-and-time expressions. Only the date parts of the values are used in the calculation.
Last updated