OpenBI Docs Buy

Time.Second

The second of a time, datetime or datetimezone, with any fraction of a second.

Group: Dates and times. Power Query M has it too: a query that uses it is written as in Power BI.

Syntax

Time.Second(dateTime as any) as nullable number
ParameterTypeDescription
dateTimeanyA time, datetime or datetimezone value; null gives null.

Returns

nullable number. The second of the minute; it can have decimals.

Examples

The second of a scan at a till

Time.Second(#datetime(2024, 3, 15, 14, 30, 12))
12

With a fraction

Time.Second(#time(9, 15, 36.25))
36.25

Time.Minute, Time.Hour, Duration.Seconds.

Last updated · OpenBI Studio 0.3.79