now

To return the current timestamp

This function gives you the exact date and time from the exact moment when the function is executed. You are creating an exact timestamp.

This can be very helpful when calculating periods or durations, which are based on date and time values.

Syntax

now()

Return

timestamp

Examples

Your result format may be different depending on your settings.

now() 

Result:

• 06/02/2021 04:45 PM (US)

• 02/06/2021 16:45 (UK)

(for example on June 2nd, 2021 at 16:45)

date(now()) + 7 

Result:

• 06/09/2021 (US)

• 09/06/2021 (UK)

(for example on June 2nd, 2021 at 16:45)

See also

today, which returns the current date without time.