DateTimeZone.ToLocal

DateTimeZone

Converts a datetimezone value to the local timezone.

Syntax

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

Parameters

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

Return Value

datetimezone — The datetimezone value converted to the local timezone.

Remarks

DateTimeZone.ToLocal converts a datetimezone value to the local timezone of the machine where the query is executed. The date and time are adjusted to reflect the local timezone offset, including daylight saving time if applicable. If the input is null, the function returns null.

Examples

Example 1: Convert UTC timestamps to local time

Table.AddColumn(
    Table.SelectColumns(
        Table.FirstN(OrderLog, 4),
        {"LogID", "Timestamp"}
    ),
    "LocalTime",
    each DateTimeZone.ToLocal(
        DateTimeZone.From(
            DateTime.From([Timestamp]) & #datetimezone(1900, 1, 1, 0, 0, 0, 0, 0)
        )
    ),
    type datetimezone
)

Result

	LogID	Timestamp	LocalTime
1	L001	1/15/2024 9:30:00 AM	1/15/2024 9:30:00 AM
2	L002	1/16/2024 2:15:00 PM	1/16/2024 2:15:00 PM
3	L003	1/18/2024 11:00:00 AM	1/18/2024 11:00:00 AM
4	L004	1/20/2024 8:45:00 AM	1/20/2024 8:45:00 AM

Example 2: Convert a UTC datetimezone to local

#table(
    type table [UTC = datetimezone, Local = datetimezone],
    {{
        #datetimezone(2024, 3, 15, 18, 0, 0, 0, 0),
        DateTimeZone.ToLocal(#datetimezone(2024, 3, 15, 18, 0, 0, 0, 0))
    }}
)