Takes a timestamp value as a parameter and returns the year specified by that timestamp.
YEAR( datetime-expression )
datetime-expression A date, time, or timestamp.
SMALLINT
The value is returned as a SMALL INT.
SQL/2003 Vendor extension.
The following example returns the value 2001.
SELECT YEAR( '2001-09-12' ); |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |