NOW( )
Returns the current date and time.
Syntax
NOW( )
Returns
The current date and time. For example:
Sep 23, 2008 11:56 AM
Example
The following example uses the DIFF_MINUTE( ) and NOW( ) functions to calculate the number of minutes from the current date and time to Christmas:
DIFF_MINUTE(NOW(), "12/25/08 12:00 AM")