Hi Fidel,
Actually, the version of SQLite that AIR uses has been customized to implement dates as julian dates and stores them as REAL. My issue arises in that I'm getting the dates originally from a MySQL DateTime column and still want to be able to use that form of formatting to query the local database with date ranges and ordering. It would be nice if there were better examples of using the AIR SQL engine. !k _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Fidel Viegas Sent: Monday, April 07, 2008 9:52 AM To: [email protected] Subject: Re: [flexcoders] AIR SQL - Datatype issues On Mon, Apr 7, 2008 at 4:22 PM, Kevin Aebig <[EMAIL PROTECTED] <mailto:kevin%40keslabs.com> com> wrote: > Hey all, > > > > I've looked at the documentation about 400 times now and can't seem to find > myself an example of using a column of datatype Date within AIR SQL. I know > that it's been customized to use Actionscript / JavaScript Date objects, but > I can't get it to work properly for the life of me. Any examples or > pointers? The database engine used in Air is SQLite. I am not that experienced with SQLite, but I suppose that there should be a DATE and TIME datatypes. I have seen people use Text and Real for storing date values. So, just do a search on the web for sqlite. All the best, Fidel.. <http://geo.yahoo.com/serv?s=97359714/grpId=12286167/grpspId=1705007207/msgI d=109106/stime=1207584342/nc1=4507179/nc2=3848644/nc3=5170406>
