Year from the date field

[thendal]

Hi all!

How i can select a year alone from a datefield.


I tried


select * from tablename where datepart(year,datefieldname)='2000';

i got this going through some books ...but its not working

could some one help me ...

-ThanX

 

[karluk]

One common way to do this is

select * from tablename where to_char(datefieldname,yyyy)='2000';

 

[karluk]

Sorry, I omitted the single quotes around the 'yyyy' format.

select * from tablename where to_char(datefieldname,'yyyy')='2000';

 

[thendal]

Thanks karluk for the quick response ....

Thanks again