Adobe did add support for dates in SQLite, see excerpt below. The problem is most third party applications that support SQLite don't understand it so you will have limited ability to work with them, for example in the Firefox SQLite Extension
For precision and for wider access to the database beyond Flex, we typically convert the date to its serial value and store that. It is highly portable and allows you to interact with it nicely. (although you have to do the conversin back obviously). Additional SQL features The following column affinity types are not supported by default in SQLite, but are supported in Adobe AIR: STRING: corresponding to the String class (equivalent to the TEXT column affinity). NUMBER: corresponding to the Number class (equivalent to the REAL column affinity). BOOLEAN: corresponding to the Boolean class. DATE: corresponding to the Date class. XML: corresponding to the ActionScript (E4X) XML class. XMLLIST: corresponding to the ActionScript (E4X) XMLList class. OBJECT: corresponding to the Object class or any subclass that can be serialized and deserialized using AMF3 (which includes most classes including custom classes, but excludes some classes including display objects and objects that include display objects as properties). From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of markflex2007 Sent: Wednesday, August 20, 2008 10:27 AM To: flexcoders@yahoogroups.com Subject: [flexcoders] Date type in AIR application? Hi, It seems SQLite doesn't have Date type. I am working in a AIR application now. I want to know how to save data with Date type to SQLite and how to read it from SQLite and convert to actionscript date type data. Do you have a simple demo? Thanks Mark
<<image001.jpg>>
<<image002.jpg>>