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.

See Also

DATE(), TIME(), TIMENOW(), TODAY()

Did this answer your question?