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.
Continue readingCategory: MariaDB
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.
Continue readingMariaDB 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.
Continue readingMariaDB 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.
6 Ways to Add a Year to a Date in MariaDB
MariaDB provides several ways to add a year or a certain number of years to a given date. For example, you might want to add 1 year, 10 years, 30 years, etc.
Here are 6 ways to add a year to a date in MariaDB.
Continue reading