how to extract only the year from the date in sql server 2008

Question

In sql server 2008  how to extract only the year from the date  In DB I have a column for date  from that I need to extract the year  Is there any function for that

User · Answer

year table column    Example   select   from mytable where year transaction day   2013

User · Answer

select year current timestamp    SQLFiddle demo

User · Answer

SQL Server Script  declare  iDate datetime set  iDate GETDATE    print year  iDate  -- for Year  print month  iDate  -- for Month  print day  iDate  -- for Day

User · Answer

Simply use  SELECT DATEPART YEAR  SomeDateColumn   It will return the portion of a DATETIME type that corresponds to the option you specify  SO DATEPART YEAR  GETDATE    would return the current year   Can pass other time formatters instead of YEAR like    DAY MONTH SECOND MILLISECOND    etc

User · Answer

---Lalmuni Demos--- create table Users   userid int date of birth date   insert into Users values 4  9 10 1991    select DATEDIFF year date of birth  getdate    -  CASE WHEN  DATEADD year  DATEDIFF year date of birth  getdate    date of birth    gt  getdate   THEN 1 ELSE 0 END  as Years   MONTH getdate   -  DATEADD year  DATEDIFF year  date of birth  getdate     date of birth    - 1 as Months   DAY getdate   -  DATEADD year  DATEDIFF year date of birth  getdate     date of birth    - 1 as Days  from users

User · Answer

the year function dose  like this   select year date column  from table name

User · Answer

DATEPART yyyy  date column  could be used to extract year  In general  DATEPART function is used to extract specific portions of a date value

User · Answer

year  date  year getdate    year  20120101    update table set column   year date column  whre        or if you need it in another table   update t    set column   year t1 date column       from table source t1      join table target t on  join condition      where

User · Answer

You can use year   function in sql to get the  year from the specified date   Syntax   YEAR   date     For more information check here

[sql] how to extract only the year from the date in sql server 2008?

Examples related to sql

Examples related to sql-server-2008

Examples related to datetime

Examples related to extract