"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
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
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
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.