EXAMPLE - Date Functions
This example illustrates to how to use date-related functions to derive specific values for a Datetime column type.
Functions:
Item | Description |
---|---|
YEAR Function | Derives the four-digit year value from a Datetime value. Source value can be a a reference to a column containing Datetime values or a literal. |
MONTH Function | Derives the month integer value from a Datetime value. Source value can be a a reference to a column containing Datetime values or a literal. |
MONTHNAME Function | Derives the full name from a Datetime value of the corresponding month as a String. Source value can be a reference to a column containing Datetime values or a literal. |
WEEKDAYNAME Function | Derives the full name from a Datetime value of the corresponding weekday as a String. Source value can be a reference to a column containing Datetime values or a literal. |
DAY Function | Derives the numeric day value from a Datetime value. Source value can be a a reference to a column containing Datetime values or a literal. |
HOUR Function | Derives the hour value from a Datetime value. Generated hours are expressed according to the 24-hour clock. |
MINUTE Function | Derives the minutes value from a Datetime value. Minutes are expressed as integers from 0 to 59. |
SECOND Function | Derives the seconds value from a Datetime value. Source value can be a a reference to a column containing Datetime values or a literal. |
Source:
date |
---|
2/8/16 15:41 |
12/30/15 0:00 |
4/26/15 7:07 |
Transformation:
Transformation Name |
|
---|---|
Parameter: Formula type | Single row formula |
Parameter: Formula | YEAR (date) |
Transformation Name |
|
---|---|
Parameter: Formula type | Single row formula |
Parameter: Formula | MONTH (date) |
Transformation Name |
|
---|---|
Parameter: Formula type | Single row formula |
Parameter: Formula | MONTHNAME (date) |
Transformation Name |
|
---|---|
Parameter: Formula type | Single row formula |
Parameter: Formula | WEEKDAYNAME (date) |
Transformation Name |
|
---|---|
Parameter: Formula type | Single row formula |
Parameter: Formula | DAY (date) |
Transformation Name |
|
---|---|
Parameter: Formula type | Single row formula |
Parameter: Formula | HOUR (date) |
Transformation Name |
|
---|---|
Parameter: Formula type | Single row formula |
Parameter: Formula | MINUTE (date) |
Transformation Name |
|
---|---|
Parameter: Formula type | Single row formula |
Parameter: Formula | SECOND (date) |
Results:
Note
If the source Datetime value does not contain a valid input for one of these functions, no value is returned. See the second_date
column below.
date | year_date | month_date | monthname_date | weekdayname_date | day_date | hour_date | minute_date | second_date |
---|---|---|---|---|---|---|---|---|
2/8/16 15:41 | 2016 | 2 | February | Monday | 8 | 15 | 41 | |
12/30/15 0:00 | 2015 | 12 | December | Wednesday | 30 | 0 | 0 | |
4/26/15 7:07 | 2015 | 4 | April | Sunday | 26 | 7 | 7 |