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. 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? Craig Craig Miller http://spatialminds.com ------------------------------------------------------------------------------ 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
