Variable formatting of datetime with DateStyle=ISO

From: Nissim <nissim(at)nksystems(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Variable formatting of datetime with DateStyle=ISO
Date: 2000-06-03 18:15:15
Message-ID: 39394B33.630F76EE@nksystems.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I just posted a message to the interfaces list about how this is causing
problems in th JDBC driver, and I'm wondering if there's a reason why
the EncodeDateTime function creates a different format string depending
on whether the date has milliseconds. Would it break anything if it
always returned:

yyyy-mm-dd hh:mm:ss.SSzzz

even if the SS will be zero, and even if the time will is null:
"00:00:00.00" (midnight)?

Also, why are there only two digits of precision on the milliseconds?
shouldn't there be three?

-Nissim

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Meskes 2000-06-03 18:57:45 Re: ecpg enhance patch
Previous Message Bruce Momjian 2000-06-03 17:53:24 Re: New warning code for missing FROM relations