Re: Arrrr... date formatting.

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.