[Haskell-cafe] Re: programmatic DB interface?

[Magnus Therning]

On Fri, Feb 5, 2010 at 10:38, Johannes Waldmann
<waldmann at imn.htwk-leipzig.de> 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