| Excerpt |
|---|
Derives the seconds value from a Datetime value. Source value can be a a reference to a column containing Datetime values or a literal. |
- If the source Datetime value does not include a valid input for this function, a missing value is returned.
- If the input values do not contain milliseconds, the generated output is expressed as integers from 0 to 59.
- If the input values contain milliseconds, the generated output is a floating point value.
| D lang syntax |
|---|
| RawWrangle | true |
|---|
| Type | ref |
|---|
| showNote | true |
|---|
| WrangleText | derive type:single value:second(MyDate) |
|---|
|
second(MyDate) |
Output: Generates a column of values that retrieve the two-digit hour values from the MyDate column.
| D lang syntax |
|---|
| RawWrangle | true |
|---|
| Type | syntax |
|---|
| showNote | true |
|---|
| WrangleText | derive type:single value:second(datetime_col) |
|---|
|
second(datetime_col) |
| Argument | Required? | Data Type | Description |
|---|
| datetime_col | Y | datetime | Name of column whose second values are to be computed |
datetime_col
Name of the column whose seconds value is to be computed.
- Missing values for this function in the source data result in missing values in the output.
- Invalid or out-of-range source values generate missing values in the output.
- Multiple columns and wildcards are not supported.
| Required? | Data Type | Example Value |
|---|
| Yes | Datetime | myDate |
Example - Date element functions
| Include Page |
|---|
| EXAMPLE - Date Functions |
|---|
| EXAMPLE - Date Functions |
|---|
|
