dates

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.

Read more

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.

Read more

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.

Read more

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.

Read more

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.

Read more

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.

Read more

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.

Read more

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).

Read more

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.

Read more

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.

Read more