There is only one row in the table? > select to_char(day, 'DD/MM/YYYY') from test_table; what happens with:
select * from test_table; or select day from test_table; What does your insert statement look like? What is the column type? Ted --- Tomás Zandoná <[EMAIL PROTECTED]> wrote: > > 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 > __________________________________ Do you Yahoo!? Meet the all-new My Yahoo! - Try it today! http://my.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
