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.

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/i...ive/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.


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

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.
select length(to_char('2005-Jun-10'::timestamp without time zone,
'FMMonth')); -> 4

Manual:
9.8. Data Type Formatting Functions
Table 9-22. Template Pattern Modifiers for Date/Time Formatting
Modifier Description Example
FM prefix fill mode (suppress padding blanks and zeroes) FMMonth


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

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@wellsgaming.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/i...ive/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.
>
>

Add to that they just re-released Sid Meier's Pirates, and I'm a hopeless
case mateys.

Alex

On 9/19/05, IanL PostgreSQL Lists <ian@dinwoodie.freeuk.com> wrote:
>
> Alex Turner wrote:
>
> > May you find much buried treasure,
>
> Somebody PLEASE burn his Privates of the Caribbean DVD!
>
>