Derives the hour value from a Datetime value. Generated hours are expressed according to the 24-hour clock.

derive type:single value:HOUR(MyDate)

Output: Generates a column of values that retrieve the two-digit hour values from the MyDate column.

derive type:single value:HOUR(datetime_col)

ArgumentRequired?Data TypeDescription
datetime_colYdatetimeName of column whose hour values are to be computed

datetime_col

Name of the column whose hour value is to be computed.

Required?Data TypeExample Value
YesDatetimemyDate

Example - Date element functions