1.1 Get the current date + time (date + times) function: Now ()
In addition to the now () function to get the current datetime, MySQL has the following function:
current_timestamp () Current_timestamp
localtime () localtime
Localtimestamp () Localtimestamp
These date-time functions are equivalent to now (). Since the now () function is short and easy to remember, it is recommended that you always use now () instead of the functions listed above.
1.2 Get the current date + time (date + times) function: Sysdate ()
The sysdate () Date-time function is similar to now (), except that it is obtained at the execution start value, and sysdate () dynamically gets the value when the function executes.
2. Get the current date (date) function: Curdate ()
where the following two date functions are equivalent to Curdate (): Current_date (), Current_date
3. Get the current time function: Curtime ()
where the following two time functions are equivalent to Curtime (): Current_time (), Current_time
4. Get the current UTC datetime function: Utc_date (), Utc_time (), Utc_timestamp ()
Database--mysql How to get the current time