On Fri, Feb 5, 2010 at 10:38, Johannes Waldmann <[email protected]> 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 [email protected] http://www.haskell.org/mailman/listinfo/haskell-cafe
