Postgres Pro
Downloads
Home   >   mailing lists

BUG #1458: to_char is crazy - Mailing list pgsql-bugs

From Tomás Zandoná
Subject BUG #1458: to_char is crazy
Date
Msg-id 20050202002753.838D09A5811@www.postgresql.com
Whole thread Raw
Responses Re: BUG #1458: to_char is crazy  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Re: BUG #1458: to_char is crazy  (Theodore Petrosky <tedpet5@yahoo.com>)
Re: BUG #1458: to_char is crazy  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
The following bug has been logged online:

Bug reference:      1458
Logged by:          Tomás Zandoná
Email address:      tdzandona@yahoo.com.br
PostgreSQL version: 7.3.2
Operating system:   i don't know
Description:        to_char is crazy
Details:

I'm from brazil. I don't wrote English very well.

I dont't know if it's a bug, but I insert the date 2005-10-09 in a Date
field.
Later I execute:

select to_char(day, 'DD/MM/YYYY') from test_table;

It returns 08/10/2005.

????? I don't understand why it returns 08 instead of 09...

Can you help me?
I'm waiting for an answare.
Thanks,
Tomás Zandoná.

pgsql-bugs by date:

Previous
From: "Filip Hrbek"
Date:
Subject: Probably libpq on windows bug
Next
From: Tom Lane
Date:
Subject: Re: BUG #1455: pg_dumpall fails