TIME DAX Function (Date and Time)

Syntax  |  Return values  |  Related  

Converts hours, minutes, and seconds given as numbers to a time in datetime format.

Syntax

TIME ( <Hour>, <Minute>, <Second> )

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

Scalar A single datetime value.

Returns the specified time.

Related functions

Other related functions are:

• DATE

Last update: Jan 23, 2021   » Contribute   » Show contributors

Contributors: Alberto Ferrari, Marco Russo

MSDN documentation: https://docs.microsoft.com/en-us/dax/time-function-dax