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.
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.
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.
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.
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.
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.
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).
In MySQL, you can use the DATE_SUB() function to subtract a specified amount of time from a date. For example, you can use it to subtract 7 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.
This function is similar to DATE_ADD(), except that it subtracts from a date instead of adds to it.
In MySQL, you can use the DATE_ADD() function to add a specified amount of time to a date. For example, you could use it to add 5 days to a given date. You can specify whether to add days, weeks, months, quarters, years, etc. You can also add a time value, such as seconds, microseconds, etc.
This article contains examples that demonstrate how the DATE_ADD() function works.
In MySQL, you can use the ADDDATE() function to add a specified amount of time to a date. For example, you could use it to add 10 days to a given date. You can specify whether to add days, weeks, months, quarters, years, etc. You can also add a time value, such as seconds, microseconds, etc.
The ADDDATE() function is a synonym for the DATE_ADD() function (they both do the same thing) when using the first syntax listed below.
This article contains examples to demonstrate usage of the ADDDATE() function.