Re: Arrrr... date formatting.

50 pieces of eight to that man there!!

You are exactly right, the FM prefix is exactly what I'm seeking! I missed
that table right below the main formaing table that describes the prefixes.

May you find much buried treasure,

Alex Turner
NetEconomist

On 9/19/05, Dianne Yumul <dianne(at)wellsgaming(dot)com> wrote:
>
> 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.
>
>