Retrieving Year part from the DateTime column

Amatya
Posted by Amatya under Sql Server category on | Points: 40 | Views : 966
The below query will give the year as a output

Select DATEPART(YEAR,myDate) as year  from tblAmatya


Thanks
Amatya

Comments or Responses

Login to post response