Re: Arrrr... date formatting.

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