Neoview SQL Reference Manual (R2.5)

SECOND Function
The SECOND function converts a TIME or TIMESTAMP expression into an INTEGER value in
the range 0 through 59 that represents the corresponding second of the hour.
SECOND is a Neoview SQL extension.
SECOND (datetime-expression)
datetime-expression
is an expression that evaluates to a datetime value of type TIME or TIMESTAMP. See
“Datetime Value Expressions” (page 257).
Example of SECOND
Return a NUMERIC value that represents the second of the hour from the SHIP_TIMESTAMP
column:
SELECT start_date, ship_timestamp, SECOND(ship_timestamp)
FROM persnl.project
WHERE projcode = 1000;
Start/Date Time/Shipped (EXPR)
---------- -------------------------- -----------
2008-04-10 2008-04-21 08:15:00.000000 .000000
SECOND Function 463