Convert number of month to name of month

From: lock_matthew(at)hotmail(dot)com (Matthew Lock)
To: pgsql-general(at)postgresql(dot)org
Subject: Convert number of month to name of month
Date: 2002-07-30 06:02:18
Message-ID: 8acb4549.0207292202.283362cd@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message frank_lupo 2002-07-30 06:34:52 Re: Execute vacuum postgresql crash
Previous Message Bruce Momjian 2002-07-30 04:26:03 Re: message issued by INSERT commands