Power Query
Search…
published
Introduction
Accessing Data
Action
Binary
Binary Formats
Combiner
Comparer
Cube
Date
Date Time
Date Time Zone
Diagnostics
Duration
Error
Expression
Function
Lines
List
Logical
Metadata
Number
Record
Replacer
Splitter
Table
Text
Time
Time.From
Time.FromText
Time.Hour
Time.Minute
Time.Second
Time.ToRecord
Time.ToText
Type
Uri
Values
Powered By
GitBook
Time.Hour
Time.Hour
Returns the hour component.
function (optional
dateTime
as nullable any) as nullable any
Description
Returns the hour component of the provided
time
,
datetime
, or
datetimezone
value,
dateTime
.
Category
Time
Examples
Find the hour in #datetime(2011, 12, 31, 9, 15, 36).
1
Time.Hour(#datetime(2011, 12, 31, 9, 15, 36))
Copied!
9
Previous
Time.FromText
Next
Time.Minute
Last modified
3yr ago
Copy link
Contents
Time.Hour
Description
Category
Examples