| From: | Dianne Yumul <dianne(at)wellsgaming(dot)com> |
|---|---|
| To: | armtuk(at)gmail(dot)com |
| Cc: | PostgreSQL List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Arrrr... date formatting. |
| Date: | 2005-09-19 15:49:34 |
| Message-ID: | f2172c5324858145deb23bf2622eb47f@wellsgaming.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
May be you want the FM prefix, i.e. to_char(current_timestamp,
'FMMonth'). See the docs for more info:
http://www.postgresql.org/docs/8.0/interactive/functions-
formatting.html#FUNCTIONS-FORMATTING-EXAMPLES-TABLE
On Sep 19, 2005, at 8:20 AM, Alex Turner wrote:
> Shiver me timbers, whats up with to_char()?!
>
> Avast! Is there no way to get a month without it being padded to
> nine characters? It makes using a database to actualy format a date
> for output kinda impossible?
>
> I'll have to walk the plank if I can't get an answer, the crew will
> mutiny and leave me on an island with a one-shot pistol and the sight
> of me sails dissapearing over the horizon!
>
> Alex Turner
> NetEconomist
> P.S. For those who didn't know - it's national talk like a pirate day.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Prasad Duggineni | 2005-09-19 15:50:34 | postgres 8.03 initdb error for Rhel ES-4 |
| Previous Message | Marc Munro | 2005-09-19 15:48:20 | Re: pg_ctl reload breaks our client |