This example illustrates how a variety of date-related functions can be used to derive specific values out of a column of Datetime type.

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 second_date column below.

dateyear_datemonth_datemonthname_dateweekdayname_dateday_datehour_dateminute_datesecond_date
2/8/16 15:4120162FebruaryMonday81541 
12/30/15 0:00201512DecemberWednesday3000 
4/26/15 7:0720154AprilSunday2677