In MariaDB, DATE() is a built-in date and time function that extracts the date part of a date or datetime expression.
You pass the date/datetime expression as an argument when calling the function.
date functions
MariaDB LOCALTIMESTAMP() Explained
In MariaDB, LOCALTIMESTAMP and LOCALTIMESTAMP() are synonyms for NOW().
The NOW() function is a built-in date and time function that returns the current date and time.
The time is returned in either 'YYYY-MM-DD HH:MM:SS' or YYYYMMDDHHMMSS.uuuuuu format, depending on whether the function is being used in a string or numeric context.
MariaDB LOCALTIME() Explained
In MariaDB, LOCALTIME and LOCALTIME() are synonyms for NOW().
The NOW() function is a built-in date and time function that returns the current date and time.
The time is returned in either 'YYYY-MM-DD HH:MM:SS' or YYYYMMDDHHMMSS.uuuuuu format, depending on whether the function is being used in a string or numeric context.
MariaDB CURRENT_TIMESTAMP() Explained
In MariaDB, CURRENT_TIMESTAMP and CURRENT_TIMESTAMP() are synonyms for NOW().
The NOW() function is a built-in date and time function that returns the current date and time.
The time is returned in either 'YYYY-MM-DD HH:MM:SS' or YYYYMMDDHHMMSS.uuuuuu format, depending on whether the function is being used in a string or numeric context.
How NOW() Works in MariaDB
In MariaDB, NOW() is a built-in date and time function that returns the current date and time.
The return value is returned in 'YYYY-MM-DD HH:MM:SS' or YYYYMMDDHHMMSS.uuuuuu format, depending on whether the function is used in a string or numeric context.
The return value is expressed in the current time zone.
You also have the option of specifying the microsecond precision.
MariaDB CURRENT_TIME() Explained
In MariaDB, CURRENT_TIME and CURRENT_TIME() are synonyms for CURTIME().
The CURTIME() function is a built-in date and time function that returns the current time.
The time is returned in either 'HH:MM:SS' or HHMMSS.uuuuuu format, depending on whether the function is being used in a string or numeric context.
How CURTIME() Works in MariaDB
In MariaDB, CURTIME() is a built-in date and time function that returns the current time.
The time is returned in either 'HH:MM:SS' or HHMMSS.uuuuuu format, depending on whether the function is being used in a string or numeric context.
You also have the option of specifying the microsecond precision.
MariaDB CURRENT_DATE() Explained
In MariaDB, CURRENT_DATE and CURRENT_DATE() are synonyms for CURDATE().
The CURDATE() function is a built-in date and time function that returns the current date.
The date is returned in either 'YYYY-MM-DD' or YYYYMMDD, depending on whether the function is being used in a string or numeric context.
How CURDATE() Works in MariaDB
In MariaDB, CURDATE() is a built-in date and time function that returns the current date.
The date is returned in either 'YYYY-MM-DD' or YYYYMMDD, depending on whether the function is being used in a string or numeric context.
How CONVERT_TZ() Works in MariaDB
In MariaDB, CONVERT_TZ() is a built-in date and time function that converts a datetime value from one time zone to another.
When you call the function, you pass three arguments: the time, the time zone to convert from, and the time zone to convert to.