Perfect. :) Craig
Craig Miller http://spatialminds.com On Sep 7, 2012, at 6:18 AM, Koen Deforche wrote: > Hey Craig, > > 2012/9/6 Craig Miller <craig.mil...@spatialminds.com>: >> So, I'm pretty sure this is a bug. >> >> I've set my Dbo Session to use ISO8601asText as my Sqlite3 SqlDateTime >> format. I have several entries in my database that conform to the ISO8601 >> specification, but they all fail to parse. If I use the following format >> 2002-01-20 23:59:59.000 things parse perfectly. >> >> My understanding of ISO8601 is that they should look like the following: >> >> 2002-01-20T23:59:59Z >> >> The T is the ISO8601 specified separator between date and time. The Z >> indicates that it is UTC time. > > The current code to parse dates from Sqlite3 is indeed not correct. > >> We're good to go on our end by switching the datetime storage format we are >> using, but I thought folks might want to know since it took quite a bit of >> time to figure out. Perhaps a few examples could be provided next to the >> ISO8601AsText enum documentation? > > I would rather like to fix this in Wt by expanding the parser to > support all of the date formats that Sqlite3 supports (which are > ISO8601 + ISO8601-like), and store dates ourselves in ISO8601 format. > > Regards, > koen > > ------------------------------------------------------------------------------ > Live Security Virtual Conference > Exclusive live event will cover all the ways today's security and > threat landscape has changed and how IT managers can respond. Discussions > will include endpoint security, mobile security and the latest in malware > threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ > _______________________________________________ > witty-interest mailing list > witty-interest@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/witty-interest ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ witty-interest mailing list witty-interest@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/witty-interest
