The following bug has been logged online: Bug reference: 1458 Logged by: Tomás Zandoná Email address: [EMAIL PROTECTED] 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á. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq