DateTime.Time

Updated on

DateTime.Time is a Power Query M function that returns the time part of the provided dateTime value. The function returns the time component of the given datetime value.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

DateTime.Time( dateTime as any ) as nullable time

Description

DateTime.Time returns the time part of the given dateTime argument, which can be of type datetime or datetimezone.

Examples

Find the time value of #datetime( 2010, 12, 31, 11, 56, 02 ).

// Output: #time( 11, 56, 2 )
DateTime.Time( #datetime( 2010, 12, 31, 11, 56, 02 ) )

Other functions related to DateTime.Time are:

BI Gorilla Youtube Channel

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/datetime-time