SECOND DAX Function (Date and Time)
Returns a number from 0 to 59 representing the second.
Syntax
| Parameter | Attributes | Description |
|---|---|---|
| Datetime |
The time in datetime format or text in time format, such as 16:48:23 or 4:48:47 PM. |
Return values
An integer number from 0 to 59.
Remarks
When the datetime argument is a text representation of the date and time, the 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. Verify your locale settings to understand your results.
Related functions
Other related functions are:
Last update: Oct 20, 2018 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://msdn.microsoft.com/en-us/query-bi/dax/second-function-dax