Returns the current date and time as of the specified or default timezone.
Sample usage
CURRENT_DATETIME()
CURRENT_DATETIME("America/Los_Angeles")")
Syntax
CURRENT_DATETIME([
time_zone
])Parameters
time_zone
- Optional. A text field or expression representing the timezone. This parameter is a string representing the timezone to use. If no timezone is specified, the default timezone UTC is used. See Timezone definitions for information on how to specify a time zone. If thetime_zone
parameter evaluates to
NULL
, this function returnsNULL
.
Return data type
Date & Time
Examples
Example formula | Input | Output |
---|---|---|
CURRENT_DATETIME() |
January 10, 2020 10:38 AM | 2020-1-10 10:38:47 |
Notes
This function is not available for compatibility mode date types.