1.a period of time containing 365 (or 366) days;
she is 4 years old
2.a period of time occupying a regular part of a calendar year that is used for some particular activity;
a school year
3.the period of time that it takes for a planet (as, e.g., Earth or Mars) to make a complete revolution around the sun;
a Martian year takes 687 of our days
4.a body of students who graduate together;
the class of '97
T-SQL中的YEAR()函數 返回表示指定日期中的年份的整數。 語法 YEAR (date ) 參數 date datetime 或 smalldatetime 類型的表達式。 返回類型 int 注釋 此函數等價于 DATEPART(yy,date)。 示例 下例從日期 03/12/1998 中返回年份數。 SELECT "Year Number" = YEAR('03/12/1998')GO 下面是結果集: Year Number ------------ 1998 下例用數字指定日期。注意:Microsoft® SQL Server™ 數據庫將 0 解釋