Postgres Pro
Downloads
Home   >   mailing lists

Convert number of month to name of month - Mailing list pgsql-general

From lock_matthew@hotmail.com (Matthew Lock)
Subject Convert number of month to name of month
Date
Msg-id 8acb4549.0207292202.283362cd@posting.google.com
Whole thread Raw
Responses Re: Convert number of month to name of month  (Oliver Elphick <olly@lfix.co.uk>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Fabiàn R.Breschi
Date:
Subject: MySQL or Postgres ?
Next
From: Brett Schwarz
Date:
Subject: Re: pgaccess libpgtcl