Data Type Of Year

[Pradyumna]

Hi, Every body, I requiest to all of u plz help me this problem.I am trying to disply only year(ex-2005)I am trying:- Create table pk(Name varchar(20),Address varchar(20),YearOfDOB datetime)insert into pk values('pradyumna','india',1982) When i select table pk then it disply fulldate and time alsoMy question is: I am trying to disply only Yeari wants to disply like this:ex:- Name Address YearOfDOB Pradyumna India 1982

[maelstorm]

HiCheck out this link belowhttp://msdn.microsoft.com/library/default...._ya-yz_0ab6.aspHTH