Re: Arrrr... date formatting.
| От | Reid Thompson |
|---|---|
| Тема | Re: Arrrr... date formatting. |
| Дата | |
| Msg-id | F71C0DC6B4FD3648815AAA7F969E35290194F5F2@sr002-2kexc.ateb.com обсуждение исходный текст |
| Ответ на | Arrrr... date formatting. (Alex Turner <armtuk@gmail.com>) |
| Список | pgsql-general |
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.
В списке pgsql-general по дате отправления: