How to get 3 letter abbreviation for month in SQL

 Admin   
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())