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 thetz database.
For a less comprehensive but simpler reference, see theList of tz database time zones on Wikipedia.
Examples:
America/Los_AngelesAmerica/Argentina/Buenos_AiresEtc/UTCPacific/AucklandWhen you use a time zone name, a space is required between the name and the restof the timestamp:
2014-09-27 12:30:00.45 America/Los_AngelesNote that not all time zone names are interchangeable even if they report thesame time during a given part of the year. For example,America/Los_Angeles reports the same time asUTC-7:00 during daylightsaving time (DST), but it reports the same time asUTC-8:00 outside of DST.
If a time zone isn't specified, the default time zone value, UTC, is used.
If thetime_zone_name parameter evaluates toNULL, this function returnsNULL.
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 forcompatibility mode date types.
Related resources
Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2026-02-19 UTC.