| Excerpt |
|---|
Generates time values from three inputs of Integer type: hour, minute, and second. |
- Source values can be Integer literals or column references to values that can be inferred as Integers.
- If any of the source values are invalid or out of range, a missing value is returned.
- This function must be nested within another function that accepts date values as arguments. See the example below.
Integer literal values:
| D lang syntax |
|---|
| RawWrangle | true |
|---|
| Type | ref |
|---|
| showNote | true |
|---|
| WrangleText | derive type:single value:dateformat(time(23,58,59),'HH mm ss') |
|---|
|
dateformat(time(23,58,59),'HH mm ss') |
Output: Returns the following map:
Column reference values:
| D lang syntax |
|---|
| RawWrangle | true |
|---|
| Type | ref |
|---|
| showNote | true |
|---|
| WrangleText | derive type:single value: dateformat(time(myHour, myMinute, mySecond), 'hh-mm-ss') |
|---|
|
dateformat(time(myHour, myMinute, mySecond), 'hh-mm-ss') |
Output: Generates a column of values where:
hh = values from myHour columnmm = values from myMinute columnss = values from mySecond column
| D lang syntax |
|---|
| RawWrangle | true |
|---|
| Type | syntax |
|---|
| showNote | true |
|---|
| WrangleText | derive type:single value:dateformat(time(hour_integer_col,minute_integer_col,second_integer_col ),'time_format_string') |
|---|
|
dateformat(time(hour_integer_col,minute_integer_col,second_integer_col ),'time_format_string') |
| Argument | Required? | Data Type | Description |
|---|
| hour_integer_col | Y | integer | Name of column or Integer literal representing the hour value to apply to the function |
| minute_integer_col | Y | integer | Name of column or Integer literal representing the minute value to apply to the function |
| second_integer_col | Y | integer | Name of column or Integer literal representing the second value to apply to the function |
| time_format_string | Y | string | String literal identifying the time format to apply to the value |
hour_integer_col
Integer literal or name of the column containing integer values for the hour. Values must integers between 0 and 23, inclusive.
- Missing values for this function in the source data result in missing values in the output.
- Multiple columns and wildcards are not supported.
| Required? | Data Type | Example Value |
|---|
| Yes | Integer (literal or column reference) | 15 |
minute_integer_col
Integer literal or name of the column containing integer values for the minutes. Values must integers between 0 and 59, inclusive.
- Missing values for this function in the source data result in missing values in the output.
- Multiple columns and wildcards are not supported.
| Required? | Data Type | Example Value |
|---|
| Yes | Integer (literal or column reference) | 23 |
second_integer_col
Integer literal or name of the column containing integer values for the second. Values must integers between 0 and 59, inclusive.
- Missing values for this function in the source data result in missing values in the output.
- Multiple columns and wildcards are not supported.
| Required? | Data Type | Example Value |
|---|
| Yes | Integer (literal or column reference) | 45 |
For more information, see DATEFORMAT Function.
Example - date and time functions
| Include Page |
|---|
| EXAMPLE - DATE and TIME Functions |
|---|
| EXAMPLE - DATE and TIME Functions |
|---|
|
