Datetimezone Functions Overview

Discover Datetimezone Functions in Power Query M Language, crucial for handling date, time and timezone values. This page provides a comprehensive list and descriptions of Datetimezone Functions available in the M Language.

Component Functions

Function	Description
DateTimeZone.ZoneHours	Extracts the hour component of the time zone from a DateTime value.
DateTimeZone.ZoneMinutes	Extracts the minute component of the time zone from a DateTime value.

Creation and Conversion Functions

Function	Description
#datetimezone	Creates a datetimezone value from numbers representing the year, month, day, hour, minute, (fractional) second, (fractional) offset-hours, and offset-minutes.
DateTimeZone.From	Creates a datetimezone from the given value.
DateTimeZone.FromFileTime	Creates a datetimezone from a 64 bits long number.
DateTimeZone.FromText	Creates a datetimezone from local, universal, and custom datetimezone formats.
DateTimeZone.ToLocal	Converts the timezone component to the local timezone.
DateTimeZone.ToRecord	Returns a record containing the datetimezone value’s parts.
DateTimeZone.ToText	Returns a textual representation of the datetimezone value.
DateTimeZone.ToUtc	Converts the timezone component to UTC timezone.

Current Value Functions

Function	Description
DateTimeZone.FixedLocalNow	Returns the current date & time in the local timezone
DateTimeZone.FixedUtcNow	Returns the current date and time in UTC (the GMT timezone)
DateTimeZone.LocalNow	Returns the current date & time in the local timezone.
DateTimeZone.UtcNow	Returns the current date and time in UTC (the GMT timezone).

Modification Functions

Function	Description
DateTimeZone.RemoveZone	Removes timezone information from the given datetimezone value.
DateTimeZone.SwitchZone	Changes the timezone of the value.

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/datetimezone-functions