Neoview SQL Reference Manual (R2.4 SP2)

YEAR Function
The YEAR function converts a DATE or TIMESTAMP expression into an INTEGER value that
represents the year.
YEAR is a Neoview SQL extension.
YEAR (datetime-expression)
datetime-expression
is an expression that evaluates to a datetime value of type DATE or TIMESTAMP. See
“Datetime Value Expressions” (page 245).
Example of YEAR
• Return an integer that represents the year from the START_DATE column in the PROJECT
table:
SELECT start_date, ship_timestamp, YEAR(start_date)
FROM persnl.project
WHERE projcode = 1000;
Start/Date Time/Shipped (EXPR)
---------- -------------------------- ------
2008-04-10 2008-04-21 08:15:00.000000 2008
476 SQL Functions and Expressions