Re: BUG #1458: to_char is crazy

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

--- Toms Zandon <tdzandona(at)yahoo(dot)com(dot)br> wrote:

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