datetime from sqlserver

rajesh_css · October 8th, 2008, 09:01 PM

Hi,

I have a table which has a column of type datetime,i want to write a query where i can get only year from my datetime column.

2004-11-16 00:00:00.000 this is the one which i have i required only 2004 on selecting.

Thanks in Advance
Raj

rajesh_css · October 8th, 2008, 09:15 PM

datepart(yyyy,getDate())

this worked out......

Old Pedant · October 8th, 2008, 09:33 PM

But much easier is:

Code:

     Year(getDate())

SQL Server provides Year(), Month(), and Day() functions. You have to use DatePart( ) for some other properties of dates, but not those three.