HOUR DAX Function (Date and Time)
Returns the hour as a number from 0 (12:00 A.M.) to 23 (11:00 P.M.).
Syntax
HOUR ( <Datetime> )
| Parameter | Attributes | Description |
|---|---|---|
| Datetime |
A datetime value or text in time format, such as 16:48:00 or 4:48:00 PM. |
Return values
Scalar A single integer value.
An integer number from 0 to 23.
Related functions
Other related functions are:
Last update: Jan 11, 2021 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://docs.microsoft.com/en-us/dax/hour-function-dax
2018-2021 © SQLBI. All rights are reserved. Information coming from MSDN is property of Microsoft Corp. » Contact us » Privacy Policy & Cookies