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) |
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.
Required? | Data Type | Example Value |
---|---|---|
Yes | Datetime | myDate |