BUG #1458: to_char is crazy

From: "Toms Zandon" <tdzandona(at)yahoo(dot)com(dot)br>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1458: to_char is crazy
Date: 2005-02-02 00:27:53
Message-ID: 20050202002753.838D09A5811@www.postgresql.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 1458
Logged by: Toms Zandon
Email address: tdzandona(at)yahoo(dot)com(dot)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,
Toms Zandon.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Kris Jurka 2005-02-02 09:39:01 timezone offsets and documentation
Previous Message Tamas Vincze 2005-02-01 20:35:05 Re: 8.0.0 make check fails on Solaris 9 (sparc)