[Haskell-cafe] Re: programmatic DB interface?
magnus at therning.org
Sat Feb 6 01:17:24 EST 2010
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.
> 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
"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
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.
Magnus Therning (OpenPGP: 0xAB4DFBA4)
magnus＠therning．org Jabber: magnus＠therning．org
http://therning.org/magnus identi.ca|twitter: magthe
More information about the Haskell-Cafe