DateTimeZone.ZoneHours
The hours of a datetimezone's offset from UTC.
Group: Dates and times. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
DateTimeZone.ZoneHours(dateTimeZone as nullable datetimezone) as nullable number| Parameter | Type | Description |
|---|---|---|
dateTimeZone | nullable datetimezone | The value; null gives null. |
Returns
nullable number. The whole hours of the offset, negative west of UTC.
Remarks
- An offset such as +05:30 gives 5 here and 30 from
DateTimeZone.ZoneMinutes; -03:30 gives -3 and -30.
Examples
An order from New York
DateTimeZone.ZoneHours(#datetimezone(2024, 3, 15, 9, 0, 0, -5, 0))-5An offset with minutes
DateTimeZone.ZoneHours(#datetimezone(2024, 3, 15, 9, 0, 0, 5, 30))5Related functions
DateTimeZone.ZoneMinutes, DateTimeZone.SwitchZone, DateTime.AddZone.