This function returns an integer representing the hour when the fraction of the expression is interpreted as a time according to the standard number interpretation.
Syntax:
hour(expression)
Return data type: integer
Examples and results:
| Example | Result |
|---|---|
|
hour( '09:14:36' ) |
returns 9 |
|
hour( '0.5555' ) |
returns 13 ( Because 0.5555 = 13:19:55 ) |
