Sunday, 1 December 2019

How to get month from a date in sqlserver

How to get month from a date in  SQL server



If  I am writing select Month(getdate()) then I am getting from month.But if I am writing this command like

Select Month('02/12/2019') then it give me month=2
but here my month is 12 what I can do

Kindly help
thanks in advance

No comments:

Post a Comment