On Fri, Feb 5, 2010 at 10:38, Johannes Waldmann 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