| From: | Maciej Bliziński <maciej(dot)blizinski(at)magnum2(dot)pl> |
|---|---|
| To: | Najib Abi Fadel <nabifadel(at)usj(dot)edu(dot)lb> |
| Cc: | generalpost <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Bug in function to_char() !! |
| Date: | 2004-07-01 08:23:29 |
| Message-ID: | 40E3CA01.6010708@magnum2.pl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Najib Abi Fadel wrote:
> Hi, i am using PostgreSQL 7.3.2
> there's a bug for the date '2005-03-27' !!!!!!!!!!!!!!!!!!!!!!!!!!!
> For other dates the function works well !!
I have 7.4.2 and it works well:
maciej(at)matylda:~$ psql template1
Welcome to psql 7.4.2, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
template1=# SELECT to_char('2005-03-27'::date,'DD/MM/YYYY');
to_char
------------
27/03/2005
(1 row)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michal Taborsky | 2004-07-01 08:50:23 | Restoring template1 |
| Previous Message | vinny | 2004-07-01 08:17:50 | Re: backups |