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
