Time.Second

Updated on

Time.Second is a Power Query M function that extracts the second component from a given time, datetime, or datetimezone value. The function returns the second component as a number.

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

Syntax

Time.Second( dateTime as any ) as nullable number

Description

Time.Second returns the second component of the provided time, datetime, or datetimezone value, dateTime and returns it as a number.

Examples

Find the second value from a datetime value.

// Output: 36.5
Time.Second( #datetime( 2011, 12, 31, 9, 15, 36.5 ) )

Other functions related to Time.Second are:

BI Gorilla Youtube Channel

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