How to display month name in a small form?

1. How to get month short name in SQL?
2. How do I shorten the month name in Excel?

How to get month short name in SQL?

In MySQL, we can use a combination of functions 'MONTHNAME' and 'STR_TO_DATE' functions to get a month name from a month number. 3. SQL SERVER: In SQL SERVER, we can use a combination of functions 'DATENAME' and 'DATEADD' functions to get a month name from a month number.

How do I shorten the month name in Excel?

Select a cell(s) with dates, press Ctrl+1 to opent the Format Cells dialog. On the Number tab, select Custom and type either "mmm" or "mmmm" in the Type box to display abbreviated or full month names, respectively.