TIME DAX Function (Date and Time)
Converts hours, minutes, and seconds given as numbers to a time in datetime format.
Syntax
Parameter | Attributes | Description |
---|---|---|
Hour |
A number from 0 to 23 representing the hour. |
|
Minute |
A number from 0 to 59 representing the minute. |
|
Second |
A number from 0 to 59 representing the second. |
Return values
Returns the specified time.
Examples
-- DATE and TIME are useful to create DateTime columns -- A DateTime is a number. Therefore, it is possible to -- sum the date and the time part. EVALUATE { DATE ( 2020, 10, 15 ), TIME ( 22, 45, 30 ), DATE ( 2020, 10, 15 ) + TIME ( 22, 45, 30 ) }
Value |
---|
2020-10-15 00:00:00 |
1899-12-30 22:45:30 |
2020-10-15 22:45:30 |
-- When the arguments overflow their range, DATE and TIME -- behave in different ways: -- -- DATE adds the excess values to the date, moving time forward -- TIME adds the excess values, but it does never exceed the day EVALUATE { DATE ( 2020, 10, 32 ), DATE ( 2020, 20, 1 ), TIME ( 10, 90, 0 ), TIME ( 50, 0, 0 ) }
Value |
---|
2020-11-01 00:00:00 |
2021-08-01 00:00:00 |
1899-12-30 11:30:00 |
1899-12-30 02:00:00 |
Related functions
Other related functions are:
Last update: Apr 2, 2021 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/time-function-dax