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.