NOW( ) Returns the current date and time. Syntax NOW( ) Returns The current date and time. For example: Feb 10, 2010 2:55 PM Example The following example uses the DIFF_DAY( ) and NOW( ) functions to calculate the number of days from the current date and time to Christmas: DIFF_DAY(NOW(), "12/25/10")