Section 1. Getting the current Date & Time
This section explains the functions that allow you to retrieve the current date, time, or both.
- CURDATE() – Return the current date. ( synonyms: CURRENT_DATE() & CURRENT_DATE).
- CURRENT_TIME – Return the current time ( synonyms: CURRENT_TIME() & CURTIME() ).
- NOW() – Return the current date and time ( synonyms: CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP, LOCALTIME(), LOCALTIMESTAMP()).
- SYSDATE() – Return the time at which it executes.
- UTC_TIMESTAMP() – Return the current UTC date and time.
- UTC_DATE() – Return the current UTC date.
- UTC_TIME() – Return the current UTC time.
‣
MySQL CURDATE() Function
‣
MySQL CURRENT_TIME
‣
MySQL NOW() Function
‣
MySQL SYSDATE Function
‣
MySQL UTC_TIMESTAMP() Function
‣
MySQL UTC_DATE() Function
‣