Retrieving Month part from the DateTime column

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

Select DATEPART(MONTH,myDate) as year  from tblAmatya


Thanks
Amatya

Comments or Responses

Login to post response