pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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?



view thread (31+ messages)  latest in thread

Message-ID: <43987799.3000401@ll.mit.edu>
Permalink:  ../43987799.3000401@ll.mit.edu/
Also on:    postgresql.org/message-id/43987799.3000401@ll.mit.edu

 · 

reply

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