CURRENT_DATETIME
Returns the current date and time according to the specified or default timezone.
Sample usage
CURRENT_DATETIME()
CURRENT_DATETIME("America/Los_Angeles")
Syntax
CURRENT_DATETIME([time_zone_name])
Parameters
time_zone_name- Optional. A text field or an expression that represents the time zone.
Time zone name
A time zone name is a tz identifier from the tz database.
For a less comprehensive but simpler reference, see the List of tz database time zones on Wikipedia.
Examples:
America/Los_Angeles
America/Argentina/Buenos_Aires
Etc/UTC
Pacific/Auckland
When you use a time zone name, a space is required between the name and the rest of the timestamp:
2014年09月27日 12:30:00.45 America/Los_Angeles
Note that not all time zone names are interchangeable even if they report the
same time during a given part of the year. For example,
America/Los_Angeles reports the same time as UTC-7:00 during daylight
saving time (DST), but it reports the same time as UTC-8:00 outside of DST.
If a time zone isn't specified, the default time zone value, UTC, is used.
If the time_zone_name parameter evaluates to NULL, this function returns NULL.
Return data type
Date & Time
Examples
| Example formula |
|---|
CURRENT_DATETIME() |
CURRENT_DATETIME("America/Los_Angeles") |
CURRENT_DATETIME("Asia/Tokyo") |
Notes
This function is not available for compatibility mode date types.