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

sql sql-server-2008 datetime extract
Praveen picture Praveen · Sep 15, 2012 · Viewed 438.1k times · Source

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?

Answer

Dumitrescu Bogdan picture Dumitrescu Bogdan · Sep 15, 2012 
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 ....

Related questions

Sql query to insert datetime in SQL Server

I want to insert a datetime value into a table(SQL Server) using the sql query below insert into table1(approvaldate)values(18-06-12 10:34:09 AM); But I get this Error msg. Incorrect syntax near '10'. I tried it with …

Read More
How can I select the first day of a month in SQL?

I just need to select the first day of the month of a given datetime variable. I know it's quite easy to do using this kind of code: select CAST(CAST(YEAR(@mydate) AS VARCHAR(4)) + '/' + CAST(MONTH(@mydate) …

Read More
Getting the current date in SQL Server?

How can I get the current date in MS-SQL Server 2008 R2? The format of the column in my database is DATETIME and dates are stored in the following format: +++++++++++++ Vrdate ++++++++++ | | | 2012-11-18 00:00:00.000 | | 2012-11-19 00:00:00.000 | | 2013-11-18 00:00:00.000 | | 2012-12-01 00:00:00.000 | | 2010-10-09 00:00:00.000 | | 2012…

Read More