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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Pierre Le Mouëllic <pierre(dot)lemouellic(at)xgs-france(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug in select to_char(now(), 'YYYY/MM/DD HH24:MI:SS:MS')
Date: 2008-06-15 02:41:15
Message-ID: 4917.1213497675@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

=?ISO-8859-1?Q?Pierre_Le_Mou=EBllic?= <pierre(dot)lemouellic(at)xgs-france(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message vidhya 2008-06-16 07:49:41 BUG #4242: Not able to open the Postgre sql
Previous Message Lawrence Cohan 2008-06-13 17:17:58 Re: BUG #4238: pg_class.relhasindex not updated by vacuum