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

SQL/MX Functions and Expressions

HP NonStop SQL/MX Reference Manual—540440-003

9-83

MINUTE Function

The MINUTE function converts a TIME or TIMESTAMP expression into an INTEGER

value, in the range 0 through 59, that represents the corresponding minute of the hour.

MINUTE 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 MINUTE

•

Return an integer that represents the minute of the hour from the

SHIP_TIMESTAMP column in the PROJECT table:

SELECT start_date, ship_timestamp, MINUTE(ship_timestamp)

FROM persnl.project

WHERE projcode = 1000;

Start/Date Time/Shipped (EXPR)

---------- -------------------------- ------

1996-04-10 1996-04-21 08:15:00.000000 15

MINUTE (datetime-expression)