NOW

Description

NOW returns the current date and time. TODAY is an alias for NOW.

Example

NOW()

This would return a text representing the current date and time in iso format, which means YYYY-MM-DD HH:MM:SS. In most use-cases the time part (HH:MM:SS) is ignored.

NOW() can be used in other calculations,

SUBTRACT_YEARS(NOW(), 18)

would return the current time 18 years ago in the same format.