MariaDB Data and Time Functions

In MariaDB, ADD_MONTHS() is a built-in function that adds a given number of months to a given date and returns the result.

In MariaDB, the ADDDATE() function adds the specified time interval to the specified date/time and returns the operation result.

In MariaDB, ADDTIME() is a built-in function that adds a specified time interval to a specified time and returns the result.

In MariaDB, CONVERT_TZ() is a built-in function used to convert a datetime value from one time zone to another.

In MariaDB, CURDATE() is a built-in function that returns the system’s current date in YYYY-MM-DD or YYYYMMDD format.

In MariaDB, CURRENT_DATE() is a built-in function that returns the system’s current date in YYYY-MM-DD or YYYYMMDD format.

In MariaDB, CURRENT_TIME() is a built-in function that returns the current time.

In MariaDB, CURRENT_TIMESTAMP() is a built-in function that returns the current date and time.

In MariaDB, CURTIME() is a built-in function that returns the current time.

In MariaDB, DATE_ADD() is a built-in function that adds the specified time interval to the specified date/time and returns the result.

In MariaDB, DATE_FORMAT() is a built-in function that formats a date/time according to a given format string.

In MariaDB, DATE_SUB() is a built-in function that subtracts the specified time interval from the specified date/time and returns the new date/time.

In MariaDB, DATE() is a built-in function that extracts date parts from the gaven datetime expression.

In MariaDB, DATEDIFF() is a built-in function that returns the difference between two dates in days.

In MariaDB, DAY() is a built-in function that returns the number representing the day of the month in a given datetime expression.

In MariaDB, DAYNAME() is a built-in function that returns the weekday name for a given date.

In MariaDB, DAYOFMONTH() is a built-in function that returns a number representing the day of the month in a datetime expression.

In MariaDB, DAYOFWEEK() is a built-in function that returns a number representing the weekday for a given date.

In MariaDB, DAYOFYEAR() is a built-in function that returns a number representing the day of the year for a given date.

In MariaDB, EXTRACT() is a built-in function that extracts specified parts from a given date or datetime expression.

In MariaDB, FROM_DAYS() is a built-in function that converts the specified number of days from standard time (0000-00-00) to a date and returns it.

In MariaDB, FROM_UNIXTIME() is a built-in function that converts a given unix timestamp to a datetime value.

In MariaDB, GET_FORMAT() is a built-in function that returns a formatted string according to the parameters.

In MariaDB, HOUR() is a built-in function that returns the hour part from a given time expression.

In MariaDB, LAST_DAY is a built-in function that returns the last day of the month for a given date.

In MariaDB, LOCALTIME() is a built-in function that returns the current date and time.

In MariaDB, LOCALTIMESTAMP() is a built-in function that returns the current date and time.

In MariaDB, MAKEDATE() is a built-in function that constructs a date base on the given year and the number of days in the year.

In MariaDB, MAKETIME() is a built-in function that creates a time from given hours, minutes, and seconds.

In MariaDB, MICROSECOND() is a built-in function that extracts the microsecond portion of a time or datetime and returns it as a number.

In MariaDB, MINUTE() is a built-in function that extracts and returns the minutes portion of a given time expression.

In MariaDB, MONTH() is a built-in function that extracts the month part from a given date expression and returns it as a number.

In MariaDB, MONTHNAME() is a built-in function that returns the month name for a given date.

In MariaDB, NOW() is a built-in function that returns the current date and time.

In MariaDB, PERIOD_ADD() is a built-in function that adds the specified number of months to the specified year and month and returns the result as a year and month.

In MariaDB, PERIOD_DIFF() is a built-in function that returns the number of months between two periods specified by year and month.

In MariaDB, QUARTER() is a built-in function that returns the quarter from a given date expression.

In MariaDB, SEC_TO_TIME() is a built-in function that returns a time value converted from a given number of seconds.

In MariaDB, SECOND() is a built-in function that returns the seconds portion of a given time expression.

In MariaDB, STR_TO_DATE() is a built-in function that converts a given date string to a date/time/datetime according to a specified format string.

In MariaDB, SUBDATE() is a built-in function that subtracts a given time interval from a given date.

In MariaDB, SUBTIME() is a built-in function that subtracts a time from a time or datetime expression.

In MariaDB, SYSDATE() is a built-in function that returns the current date and time.

In MariaDB, TIME_FORMAT() is a built-in function that formats a given time according to a given format.

In MariaDB, TIME_TO_SEC() is a built-in function that converts a given time value to seconds.

In MariaDB, TIME() is a built-in function that extracts the time part from a given time or datetime expression and returns it as a string.

In MariaDB, TIMEDIFF() is a built-in function that returns the difference between two time or datetime values.

In MariaDB, TIMESTAMP() is a built-in function that sums all arguments and returns the result as a datetime value.

In MariaDB, TIMESTAMPADD() is a built-in function that adds the specified time interval to a datetime value and returns the result.

In MariaDB, TIMESTAMPDIFF() is a built-in function that returns the difference between two datetimes.

In MariaDB, TO_DAYS() is a built-in function that returns the number of days since 0 year (0000-00-00) for a given date.

In MariaDB, TO_SECONDS() is a built-in function that returns the number of seconds since the 0 year (0000-00-00) for a given datetime.

In MariaDB, UNIX_TIMESTAMP() is a built-in function that converts a specified date/datetime to a UNIX timestamp value.

In MariaDB, UTC_DATE() is a built-in function that returns the current UTC date.

In MariaDB, UTC_TIME() is a built-in function that returns the current UTC time.

In MariaDB, UTC_TIMESTAMP() is a built-in function that returns the current UTC date and time.

In MariaDB, WEEK() is a built-in function that returns the week of the year for a given date.

In MariaDB, WEEKDAY() is a built-in function that returns the weekday number for a given date.

In MariaDB, WEEKOFYEAR() is a built-in function that returns the week number for a given date.

In MariaDB, YEAR() is a built-in function that returns the year from a given date expression.

In MariaDB, YEARWEEK() is a built-in function that returns the year and week number of a given date.