Re: [BUGS] BUG #1458: to_char is crazy

2005-02-03 Thread Tom Lane
"Tomás Zandoná" <[EMAIL PROTECTED]> writes: > 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/') from test_table; > It returns 08/10/2005. What timezone are you using, and is midnight 2005-10-09 a daylight-savin

Re: [BUGS] BUG #1458: to_char is crazy

2005-02-03 Thread Theodore Petrosky
There is only one row in the table? > select to_char(day, 'DD/MM/') 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 fo

Re: [BUGS] BUG #1458: to_char is crazy

2005-02-02 Thread Alvaro Herrera
On Wed, Feb 02, 2005 at 12:27:53AM +, Tomás Zandoná wrote: Hey Tomás, > 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/') from test_table; > > It returns 08/10/2005. > > ? I don't understand why i

[BUGS] BUG #1458: to_char is crazy

2005-02-02 Thread Tomás Zandoná
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.