Skip to content

SECOND

The seconds past the minute of a date with a time, 0 to 59.

Group: Date and time. Compatible with DAX.

Syntax

SECOND ( <time> )

Parameter	Type	Description
`time`	Date	A date with a time, a time, or text that reads as one.

Returns

Whole number. The second within the minute, 0 to 59.

Remarks

A blank gives BLANK.
For the seconds between two date-times, use DATEDIFF with SECOND.
Text such as "14:30:20" is read as a time.

Examples

Seconds of a few times

EVALUATE
ROW (
    "Time", SECOND ( TIME ( 8, 15, 42 ) ),
    "Text", SECOND ( "14:30:20" ),
    "Date and time", SECOND ( DATE ( 2024, 3, 15 ) + TIME ( 18, 5, 9 ) )
)

Time	Text	Date and time
42	20	9

MINUTE, HOUR, TIME.

Last updated 3 November 2026 · OpenBI Studio 0.3.74