How to extract only a year from a date in SQL Server 2008?

Question

In sql server 2008, how to extract only a year from the date. In the DB, I have a column for the date from which I need to extract the year. Is there any function for this?

Answer 1

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 .... 

Answer 2

 select year(current_timestamp) 

SQLFiddle demo

Answer 3

You can use the year() function in sql to get the year from the specified date.

Syntax:

 YEAR ( date ) 

Check here for more information.

Answer 4

 year(table_column) 

Example:

 select * from mytable where year(transaction_day)='2013' 

Answer 5

SQL Server Script

 declare @iDate datetime set @iDate=GETDATE() print year(@iDate) -- for Year print month(@iDate) -- for Month print day(@iDate) -- for Day 

Answer 6

DATEPART (yyyy, date_column) can be used to retrieve the year. In general, the DATEPART function is used to retrieve specific parts of a date value.

Answer 7

 ---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)) > 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 

Answer 8

Just use

SELECT DATEPART (YEAR, SomeDateColumn)

It will return the part of the DATETIME type that matches the specified parameter. SO DATEPART (YEAR, GETDATE ()) will return the current year.

Can transmit other time formats instead of YEAR, for example

• DAY
• MONTH
• SECOND
• millisecond
• ... etc..

Answer 9

year of dose function like this:

select year(date_column) from table_name