Re: Bug in select to_char(now(), 'YYYY/MM/DD HH24:MI:SS:MS') - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Bug in select to_char(now(), 'YYYY/MM/DD HH24:MI:SS:MS')
Date
Msg-id 4917.1213497675@sss.pgh.pa.us
Whole thread Raw
In response to Bug in select to_char(now(), 'YYYY/MM/DD HH24:MI:SS:MS')  (Pierre Le Mouëllic <pierre.lemouellic@xgs-france.com>)
List pgsql-bugs
Pierre Le Mouëllic <pierre.lemouellic@xgs-france.com> writes:
> Sometimes, when we run the SQL request :
> select to_char(now(), 'YYYY/MM/DD HH24:MI:SS:MS')
> we've got the result :
> 2008/06/11 15:01:06:1000

This is fixed in 8.3 and up:
http://archives.postgresql.org/pgsql-committers/2007-02/msg00334.php

It was not back-patched because it could change the behavior in cases
that weren't clearly errors.
        regards, tom lane


pgsql-bugs by date:

Previous
From: "Lawrence Cohan"
Date:
Subject: Re: BUG #4238: pg_class.relhasindex not updated by vacuum
Next
From: "vidhya"
Date:
Subject: BUG #4242: Not able to open the Postgre sql