DateTimeZone.ToUtc

DateTimeZone

Converts a datetimezone value to UTC.

Syntax

DateTimeZone.ToUtc(dateTimeZone as nullable datetimezone) as nullable datetimezone

Parameters

Name	Type	Required	Description
`dateTimeZone`	`datetimezone`	Yes	The datetimezone value to convert to UTC.

Return Value

datetimezone — The datetimezone value converted to UTC.

Remarks

DateTimeZone.ToUtc converts a datetimezone value to UTC (Coordinated Universal Time) by adjusting the date and time according to the timezone offset and setting the offset to +00:00. If the input is null, the function returns null.

Examples

Example 1: Convert timezone-aware values to UTC

let
    Source = #table(
        type table [City = text, LocalTime = datetimezone],
        {
            {"New York", #datetimezone(2024, 1, 15, 9, 30, 0, -5, 0)},
            {"London", #datetimezone(2024, 1, 15, 14, 30, 0, 0, 0)},
            {"Tokyo", #datetimezone(2024, 1, 15, 23, 30, 0, 9, 0)}
        }
    )
in
    Table.AddColumn(
        Source,
        "UTC",
        each DateTimeZone.ToUtc([LocalTime]),
        type datetimezone
    )

Result

	City	LocalTime	UTC
1	New York	1/15/2024 2:30:00 PM	1/15/2024 2:30:00 PM
2	London	1/15/2024 2:30:00 PM	1/15/2024 2:30:00 PM
3	Tokyo	1/15/2024 2:30:00 PM	1/15/2024 2:30:00 PM

Example 2: Convert a single datetimezone to UTC

#table(
    type table [EST = datetimezone, UTC = datetimezone],
    {{
        #datetimezone(2024, 3, 15, 10, 0, 0, -5, 0),
        DateTimeZone.ToUtc(#datetimezone(2024, 3, 15, 10, 0, 0, -5, 0))
    }}
)