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
| Parameter | Type | Description |
|---|---|---|
dateTime | any | A 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