0
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.
Reply
Content aside
Related Articles