The MySQL NOW() function returns the current date and time. The value is returned in ‘YYYY-MM-DD HH:MM:SS’ or YYYYMMDDHHMMSS format, depending on whether the function is used in a string or numeric context.
Here’s how it works.
Continue reading
Category: DBMS
Database Management Systems
CURRENT_TIME Examples – MySQL
In MySQL, the CURRENT_TIME function can be used to return the current time.
This function is actually a synonym for CURTIME() which returns the current time, so you can choose which function you prefer to use.
Both functions return the current time as a value in ‘HH:MM:SS’ or HHMMSS format, depending on whether the function is used in a string or numeric context.
CURTIME() Examples – MySQL
In MySQL, the CURTIME() function is used to return the current time.
More specifically, it returns the current date as a value in ‘HH:MM:SS’ or HHMMSS format, depending on whether the function is used in a string or numeric context.
CURRENT_DATE Examples – MySQL
In MySQL, the CURRENT_DATE function can be used to return the current date.
Actually, this function is a synonym for CURDATE() which returns the current date (so you can choose which one you prefer).
Both functions return the current date as a value in ‘YYYY-MM-DD’ or YYYYMMDD format, depending on whether the function is used in a string or numeric context.
CURDATE() Examples – MySQL
In MySQL, the CURDATE() function is used to return the current date.
More specifically, it returns the current date as a value in ‘YYYY-MM-DD’ or YYYYMMDD format, depending on whether the function is used in a string or numeric context.
CONVERT_TZ() Examples – MySQL
In MySQL, you can convert a datetime value between one time zone to another using the CONVERT_TZ() function. This function accepts 3 arguments; the datetime value, the original time zone, and the time zone to convert to.
Syntax and examples below.
ADDTIME() Examples – MySQL
In MySQL, you can use the ADDTIME() function to add a specified amount of time to a time or datetime expression.
Examples of this function below.
SUBDATE() vs DATE_SUB() in MySQL: What’s the Difference?
The difference between the MySQL SUBDATE() and DATE_SUB() functions is exactly the same as the difference between the ADDDATE() and DATE_ADD() functions. One function allows for two different syntax forms, whereas the other allows for just one.
This article demonstrates the difference.
ADDDATE() vs DATE_ADD() in MySQL: What’s the Difference?
When using MySQL, we have the option of using the ADDDATE() and DATE_ADD() functions whenever we want to add a specific time interval to a given date. Both these functions do the same thing, but there is one difference between them.
This article demonstrates the difference between ADDDATE() and DATE_ADD() in MySQL.
SUBDATE() Examples – MySQL
In MySQL, you can use the SUBDATE() function to subtract a specified amount of time from a date. For example, you could use it to subtract 10 days from a given date. You can specify whether to subtract days, weeks, months, quarters, years, etc. You can also subtract a time value, such as seconds, microseconds, etc.
When using the first syntax listed below, the SUBDATE() function is a synonym for the DATE_SUB() function (similar to how ADDDATE() is a synonym for DATE_ADD() when using the same syntax).