From: David Rysdam <drysdam@ll.mit.edu>
Cc: pgsql-general@postgresql.org
Subject: Re: date format
Date: Thu, 08 Dec 2005 13:12:41 -0500
Message-ID: <43987799.3000401@ll.mit.edu> (raw)
In-Reply-To: <43987540.1050709@ll.mit.edu>
References: <439870FF.4080002@ll.mit.edu>
<43987540.1050709@ll.mit.edu>
David Rysdam wrote:
> David Rysdam wrote:
>
>> I could swear (but I don't think I can prove at this point) that 8.0
>> beta3 returned timestamps with milliseconds, like this:
>>
>> YYYY-MM-DD HH24:MI:SS.MS
>>
>> But 8.1 isn't doing that. I see functions to format the date, but
>> that would require me to change all my existing SQL to specifically
>> ask for the milliseconds. There's also the "set datestyle" thing,
>> but the granularity doesn't exist to specify an exact format such as
>> the above. Is there a way to tell postgres *exactly* what I want the
>> *default* date output format to be?
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 4: Have you searched our list archives?
>>
>> http://archives.postgresql.org
>>
>>
> Nevermind, the documentation just seems to be unclear. I do get .MS
> back in ISO format (despite that not being shown as part of the ISO
> format). It's just that none of my dates have milliseconds on them,
> which is simply a bug I'll have to find.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
>
OK, sorry to flood on this, but there is still a problem. If I have no
milliseconds, I'd like to get back ".000" at the end of the output.
Since MS are indeed part of the ISO format, why don't get I get zeros?
Alternatively, if MS aren't part of the ISO format, why do I get non-zeros?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: drysdam@ll.mit.edu
Subject: Re: date format
In-Reply-To: <43987799.3000401@ll.mit.edu>
References: <439870FF.4080002@ll.mit.edu> <43987540.1050709@ll.mit.edu> <43987799.3000401@ll.mit.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox