NOW()

 

Description

This function returns the datetime value corresponding to the current system time and date.

 

Refer to DATE for more information on datetime values.

 

Examples

 

NOW() = 33139.37

Where 33139.37 represents September 23, 1990 at 8:52:48 A.M.

 

MONTH(NOW()) = 9

 

HOUR(NOW()) = 8