View Source

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

Source value can be a reference to a column containing literal or Datetime values.
If the source Datetime value does not include a valid input for this function, a missing value is returned.

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)

Argument	Required?	Data Type	Description
datetime_col	Y	datetime	Name of column whose hour values are to be computed

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

Missing values for this function in the source data result in missing values in the output.
Invalid or out-of-range source values generate missing values in the output.
Multiple columns and wildcards are not supported.

Required?	Data Type	Example Value
Yes	Datetime	`myDate`