← Back to Time functions

Time.Second

This function retrieves the second value from the specified time, datetime, or datetimezone data type, referred to as dateTime.

Syntax

Time.Second(dateTime as any) as nullable number

About

This function retrieves the second value from the specified time, datetime, or datetimezone data type, referred to as dateTime.

Explanation

Locating the secondary value from a date and time value can be achieved by utilizing Power Query function MTime.Second. For instance, when applying this function to the datetime value #datetime(2011, 12, 31, 9, 15, 36.5), the output will be 36.5.