Date & Time Functions
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 one 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. |
| ADD_MONTHS | Adds a number of months to a date. |
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.
© 2021 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/