Month Name

• jagjitsingh

  Ten Centuries

  Points: 1059

  More actions

  December 12, 2021 at 4:58 am

  Go to Answer

  #3962783

  Hi

  How to get Month Name from Date field

  Thanks

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  December 12, 2021 at 7:01 am

  Answer

  #3962804

  DATENAME

  https://docs.microsoft.com/en-us/sql/t-sql/functions/datename-transact-sql?view=sql-server-ver15

  SELECT DATENAME(mm,’2021-12-12’)