Reference
No results for 'undefined'
    Powered by Algolia

    TO_UTC_AT_OFFSET

    Converts the date/time in first argument to the date/time at the specified UTC offset. If from_utc_offset is specified, uses this UTC offset instead of CURRENT_UTC_OFFSET().

    Syntax

    =TO_UTC_AT_OFFSET(date_time, to_utc_offset, [from_utc_offset])

    Parameters

    1. date_time
      • Type: Any
      • Description: A date/time value (in Excel-style format)
    2. to_utc_offset
      • Type: String
      • Description: The target UTC offset, a string like "UTC+8:30"
    3. from_utc_offset [optional]
      • Type: String
      • Description: The UTC offset to use instead of the CURRENT_UTC_OFFSET(), a string like "UTC+8:30"

    Returns

    • Type: Any
    • Description: Resulting value

    Example

    =TO_UTC_AT_OFFSET(NOW(), "UTC-7")

    See Also

    Contents