How to get 3 letter abbreviation for month in SQL

312 View    Jan 10 2020 6:42PM

How to get month in 3 letters in SQL.


In SQL Table data is inserted:



Try this (I am assuming you are using Sql Server).


Select Convert(char(3), GetDate(), 0)


If you need full name of month, try


Select Datename(month, GetDate())