Bug in select to_char(now(), 'YYYY/MM/DD HH24:MI:SS:MS')

From: Pierre Le Mouëllic <pierre(dot)lemouellic(at)xgs-france(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug in select to_char(now(), 'YYYY/MM/DD HH24:MI:SS:MS')
Date: 2008-06-11 14:48:20
Message-ID: 484FE5B4.30205@xgs-france.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi,

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

instead of :

2008/06/11 15:01:07:000

Our version of postgres is PostgreSQL 8.2.6 64-bit on
i386-pc-solaris2.10, compiled by /ws/on10-tools/SUNWspro/SS11/bin/cc -Xa

Thanks for your prompt answer.

Pierre Le Mouëllic

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Arkady Sherman 2008-06-12 14:09:39 BUG #4233: Unable to install postgresql-8.3.3 into WindowsXP, an installer error
Previous Message Merlin Moncure 2008-06-11 13:57:03 Re: No way to list DDL for a new type