DAX Date & Time - SECOND function

Description

Returns the seconds of a time value, as a number from 0 to 59.

Syntax

SECOND (<datetime>) 

Parameters

Return Value

An integer number from 0 to 59.

Remarks

The parameter to the SECOND function is the time that contains the second you want to find.

You can specify the time as one of the following −

• Output of a date/time function.
• An expression that returns a datetime value.
• A value in one of the accepted time formats.
• An accepted text representation of a time.

DAX SECOND function uses the locale and date/time settings of the client computer to understand the text value in order to perform the conversion. Most locales use the colon (:) as the time separator and any input text using colons as time separators will parse correctly. Review your locale settings to understand your results.

Example

= SECOND ("18:15:45") returns 45. 
= SECOND ("2:15:05") returns 5. 
= SECOND (NOW ()) returns 57 if NOW () returns 12/16/2016 10:07:57 AM.