Storing a date in SQLite
Hi,
I am having a problem wth storing a date into the local SQLite-database out of
an AIR-application. After a few loops the following query is generated:
insert into UsageLog (StartUsage) values (DATETIME('2008-10-09 22:23:50'))
If I run this query directly in SQLite Administrator (tool for controlling
your SQLite databases) this gives the expected result. But if this query is
executed from out of the Flex AIR-application some strange date is put in the
database (30-12-1899 0:43:32).
Any help is appreciated.
|