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.