Functions for handling date and time, e.g. TIME, DATE, DAYNAME etc.
| Title | Description |
|---|---|
| Microseconds in MariaDB | Microseconds have been supported since MariaDB 5.3. |
| Date and Time Units | Date or time units |
| ADDDATE | Add days or another interval to a date. |
| ADDTIME | Adds a time to a time or datetime. |
| CONVERT_TZ | Converts a datetime from on time zone to another. |
| CURDATE | Returns the current date. |
| CURRENT_DATE | Synonym for CURDATE(). |
| CURRENT_TIME | Synonym for CURTIME(). |
| CURRENT_TIMESTAMP | Synonym for NOW(). |
| CURTIME | Returns the current time. |
| DATE FUNCTION | Extracts the date portion of a datetime. |
| DATEDIFF | Difference in days between two date/time values. |
| DATE_ADD | Date arithmetic - addition. |
| DATE_FORMAT | Formats the date value according to the format string. |
| DATE_SUB | Date arithmetic - subtraction. |
| DAY | Synonym for DAYOFMONTH(). |
| DAYNAME | Return the name of the weekday. |
| DAYOFMONTH | Returns the day of the month. |
| DAYOFWEEK | Returns the day of the week index. |
| DAYOFYEAR | Returns the day of the year. |
| EXTRACT | Extracts a portion of the date. |
| FROM_DAYS | Returns a date given a day. |
| FROM_UNIXTIME | Returns a datetime from a Unix timestamp. |
| GET_FORMAT | Returns a format string. |
| HOUR | Returns the hour. |
| LAST_DAY | Returns the last day of the month. |
| LOCALTIME | Synonym for NOW(). |
| LOCALTIMESTAMP | Synonym for NOW(). |
| MAKEDATE | Returns a date given a year and day. |
| MAKETIME | Returns a time. |
| MICROSECOND | Returns microseconds from a date or datetime. |
| MINUTE | Returns a minute from 0 to 59. |
| MONTH | Returns a month from 1 to 12. |
| MONTHNAME | Returns the full name of the month. |
| NOW | Returns the current date and time. |
| PERIOD_ADD | Add months to a period. |
| PERIOD_DIFF | Number of months between two periods. |
| QUARTER | Returns year quarter from 1 to 4. |
| SECOND | Returns the second of a time. |
| SEC_TO_TIME | Converts a second to a time. |
| STR_TO_DATE | Converts a string to date. |
| SUBDATE | Subtract a date unit or number of days. |
| SUBTIME | Subtracts a time from a date/time. |
| SYSDATE | Returns the current date and time. |
| TIME Function | Extracts the time. |
| TIMEDIFF | Returns the difference between two date/times. |
| TIMESTAMP FUNCTION | Return the datetime, or add a time to a date/time. |
| TIMESTAMPADD | Add interval to a date or datetime. |
| TIMESTAMPDIFF | Difference between two datetimes. |
| TIME_FORMAT | Formats the time value according to the format string. |
| TIME_TO_SEC | Returns the time argument, converted to seconds. |
| TO_DAYS | Number of days since year 0. |
| TO_SECONDS | Number of seconds since year 0. |
| UNIX_TIMESTAMP | Returns a Unix timestamp. |
| UTC_DATE | Returns the current UTC date. |
| UTC_TIME | Returns the current UTC time. |
| UTC_TIMESTAMP | Returns the current UTC date and time. |
| WEEK | Returns the week number. |
| WEEKDAY | Returns the weekday index. |
| WEEKOFYEAR | Returns the calendar week of the date as a number in the range from 1 to 53. |
| YEAR | Returns the year for the given date. |
| YEARWEEK | Returns year and week for a date. |
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/date-time-functions/