Thread: 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.
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)
date_part
-----------
9
(1 row)
test=> select length(date_part('month',current_date));
length
--------
1
(1 row)
length
--------
1
(1 row)
reid
-----Original Message-----Shiver me timbers, whats up with to_char()?!
From: Alex Turner [mailto:armtuk@gmail.com]
Sent: Monday, September 19, 2005 11:21 AM
To: PostgreSQL List
Subject: [GENERAL] Arrrr... date formatting.
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/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.
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
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
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/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.
Add to that they just re-released Sid Meier's Pirates, and I'm a hopeless case mateys.
Alex
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!