MYSQL 6 return Time Date function

Method 1,

Curdate (), Curtime (), now ()

Method 2,

Utc_date (), Utc_time (), Utc_datetime ();

You can see that UTC time is 8 hours smaller than the eight area.

Attention

Functions that return their current date or time are evaluated once at the beginning of each query execution.

This means that in a single query, multiple accesses to functions such as now () will always get the same result this principle also applies To

Curdate (), Curtime (), Utc_date (), Utc_time (), Utc_timestamp (), and all functions that have the same meaning.

MYSQL 6 return Time Date function