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:
Results:
NOTE: If the source Datetime value does not contain a valid input for one of these functions, no value is returned. See the |
| 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 |