Excerpt |
---|
Derives the full name from a Datetime value as a String. Source value can be a reference to a column containing Datetime values or a literal. |
Info |
---|
NOTE: If the source Datetime value does not include a valid input for this function, a missing value is returned. |
D code |
---|
derive type:single value:MONTHNAME(MyDate) |
Output: Generates a column of values containing the month name from the MyDate
column.
D code |
---|
derive type:single value:MONTHNAME(datetime_col) |
Argument | Required? | Data Type | Description |
---|
datetime_col | Y | datetime | Name of column whose month name values are to be computed |
datetime_col
Name of the column whose month name value is to be computed.
- 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 | Datetime | myDate |
Example - Date element functions
Include Page |
---|
| EXAMPLE - Date Functions |
---|
| EXAMPLE - Date Functions |
---|
|