- DAX Functions Tutorial
- DAX Functions - Home
- DAX Functions - Introduction
- DAX Parameter Naming Conventions
- Description Structure
- DAX Functions - Aggregation
- DAX Functions - Filter
- DAX Functions - Time Intelligence
- DAX Functions - Date and Time
- DAX Functions - Information
- DAX Functions - Logical
- Math & Trigonometric Functions
- DAX Functions - Parent & Child
- DAX Functions - Statistical
- DAX Functions - Text
- DAX Functions - Other
- DAX Functions Useful Resources
- DAX Functions - Quick Guide
- DAX Functions - Useful Resources
- DAX Functions - Discussion
DAX Date & Time - SECOND function
Description
Returns the seconds of a time value, as a number from 0 to 59.
Syntax
SECOND (<datetime>)
Parameters
Sr.No. | Parameter & Description |
---|---|
1 |
datetime A datetime value representing time. E.g. 18:15:15 or 5:45:15 P.M. |
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.
dax_functions_date_time.htm
Advertisements