When using MySQL, you can use the DATE() function to extract the date part from a date or datetime expression.
Here’s how it works.
Category: MySQL
SYSDATE() vs NOW() in MySQL: What’s the Difference?
When returning the current date/time in MySQL, there are a range of functions you can choose from. Most of these are simply synonyms for another function.
However, there are two functions that appear to do the same thing, but are in actual fact, slightly different. The functions I’m referring to are SYSDATE() and NOW().
SYSDATE() Examples – MySQL
The MySQL SYSDATE() 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.
This function is similar to NOW() but with a subtle difference. SYSDATE() returns the time at which it executes. NOW() returns the time at which the statement started executing.
Continue reading
CURRENT_TIMESTAMP Examples – MySQL
NOW() Examples – MySQL
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
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.