PowerQuery
Home
Blog
Functions
Patterns
Showcases
← Back to Time functions
Time.Hour
This function retrieves the hour part of the input time value, which can be a date, time, or time zone value.
Syntax
Time.Hour(dateTime as any) as nullable number
About
This function retrieves the hour part of the input time value, which can be a date, time, or time zone value.
Explanation
Identify the hour from the date and time #datetime(2011, 12, 31, 9, 15, 36) using the Power Query MTime.Hour function. The output will be 9.