Arrrr... date formatting.
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.
provide an example of what you're trying to do.
test=> select date_part('month',current_date);
date_part
-----------
9
(1 row)
test=> select length(date_part('month',current_date));
length
--------
1
(1 row)
reid
-----Original Message-----
From: Alex Turner [mailto:armtuk@gmail.com]
Sent: Monday, September 19, 2005 11:21 AM
To: PostgreSQL List
Subject: [GENERAL] Arrrr... date formatting.
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.
Import Notes
Resolved by subject fallback
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
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:
Show quoted text
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.
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
Show quoted text
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/interactive/functions-
formatting.html#FUNCTIONS-FORMATTING-EXAMPLES-TABLEOn 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
Show quoted text
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!
Import Notes
Reply to msg id not found: 432EFA3F.4080104@dinwoodie.freeuk.com