Convert number of month to name of month

How do I build a query that takes a field containing the number of the
month (1, 2, ..12) and displays it as the name of the month (Jan, Feb,
..Dec)?

For example:
1 as Jan
2 as Feb
etc.