Examples
(NOW() - 1) gives the date & time one day in the past. Equivalent to (NOW() - "024:00:00").
(NOW() + 1) gives the date & time one day in the future.
(NOW() + 7) gives the date & time one week in the future.
DATE(NOW()) gives the current date as a Date value. Equivalent to TODAY(). See also: DATE(), TODAY().
TIME(NOW()) gives the current time. Equivalent to TIMENOW(). See also: TIME(), TIMENOW().
Syntax
NOW()
Return Value
A DateTime value: the current date & time.