EXAMPLE - Date Functions
This example illustrates how a variety of date-related functions can be used to derive specific values out of a column of Datetime type.
YEAR- Returns the four-digit year value from a Datetime value. See YEAR Function.MONTH- Returns the two-digit month value from a Datetime value. See MONTH Function.MONTHNAME- Returns the full month name value from a Datetime value. See MONTHNAME Function.WEEKDAYNAME- Returns the weekday name value from a Datetime value. See WEEKDAYNAME Function.DAY- Returns the day of the month as a numeric value from a Datetime value. See DAY Function.HOUR- Returns the hour value on a 24-hour scale from a Datetime value. See HOUR Function.MINUTE- Returns the minutes value from a Datetime value. See MINUTE Function.SECOND- Returns the seconds value from a Datetime value. See SECOND Function.
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 |