SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Reference Manual—540440-003
9-65
HOUR Function
HOUR Function
The HOUR function converts a TIME or TIMESTAMP expression into an INTEGER
value in the range 0 through 23 that represents the corresponding hour of the day.
HOUR is an SQL/MX extension.
datetime-expression
is an expression that evaluates to a datetime value of type TIME or TIMESTAMP.
See Datetime Value Expressions on page 6-39.
Examples of HOUR
•
Return an integer that represents the hour of the day from the SHIP_TIMESTAMP
column in the PROJECT table:
SELECT start_date, ship_timestamp, HOUR(ship_timestamp)
FROM persnl.project
WHERE projcode = 1000;
Start/Date Time/Shipped (EXPR)
---------- -------------------------- ------
1996-04-10 1996-04-21 08:15:00.000000 8
HOUR (datetime-expression)