Datetime in sqlserver 2005

[raj]

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

[Roy Harvey (SQL Server MVP)]

On Wed, 8 Oct 2008 19:06:09 -0700 (PDT), raj <2r*******@gmail.com>
wrote:

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

SELECT datepart(year,datetimecolumn)
FROM Whatever

Note that this returns an INT datatype.

Roy Harvey
Beacon Falls, CT

[sqlmonkey]

On Oct 9, 3:06*am, raj <[e-mail]:

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

select year(datetimecolumn) from table