Determining the Current Date or Time
Problem
What’s the date? What time is it?
Solution
Use the NOW( )
,
CURDATE( )
, or CURTIME( )
functions.
Discussion
Some applications need to know the current date or time, such as those that produce a datestamped or timestamped status display. This kind of information is also useful for date calculations that are performed in relation to the current date, such as finding the first (or last) day of the month, or determining the date for Wednesday of next week.
The current date and time are available through three functions.
NOW( )
returns both the current date and time.
CURDATE( )
and CURTIME( )
return the date and time separately:
mysql> SELECT NOW( ), CURDATE( ), CURTIME( );
+---------------------+------------+-----------+
| NOW( ) | CURDATE( ) | CURTIME( ) |
+---------------------+------------+-----------+
| 2002-07-15 10:59:30 | 2002-07-15 | 10:59:30 |
+---------------------+------------+-----------+
CURRENT_TIMESTAMP
and SYSDATE( )
are synonyms for NOW( )
.
CURRENT_DATE
and CURRENT_TIME
are synonyms for CURDATE( )
and CURTIME( )
.
If you want to obtain subparts of these values (such as the current day of the month or current hour of the day), read the next few sections.
Get MySQL Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.