|
|
On Fri, Feb 5, 2010 at 10:38, Johannes Waldmann
<waldmann@xxxxxxxxxxxxxxxxxxx> wrote:
>
>> As I posted earlier, using 'T' to separate date and time is correct
>> ISO8601 according to wikipedia[1].
>
> So you're saying Â"2009-12-20 16:55:57.297"
> (returned by the psql server) is wrong,
> and it should instead send "2009-12-20T16:55:57.297Z" ?
Well, it isn't necessarily *wrong* ;-)
"2009-12-20 16:55:57.297" is made up of two pieces, one for date and one
for time.
"2009-12-20T16:55:57.297Z" is made up of one piece, which specifies both
date and time.
This is why I believe that the function ISO8601DateFormat is correct when
it provides a format for a combined date and time.
> What would be the query to obtain this format?
>
> I don't see this mentioned anyplace on
> http://www.postgresql.org/docs/8.3/interactive/functions-datetime.html
Neither do I, I don't find anything relating to ISO8601 dates (they seem
more concerned with ISO DOW and year).
> Perhaps we take this back to haskell-cafe (or libraries?) as it might be
> of general interest.
Sure, why not. It was most likely a mistake on my side to drop
haskell-cafe in the first place.
/M
--
Magnus Therning (OpenPGP: 0xAB4DFBA4)
magnusïtherningïorg Jabber: magnusïtherningïorg
http://therning.org/magnus identi.ca|twitter: magthe
_______________________________________________
Haskell-Cafe mailing list
Haskell-Cafe@xxxxxxxxxxx
http://www.haskell.org/mailman/listinfo/haskell-cafe
|
|