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 解释