0 Replies Latest reply on Oct 9, 2008 1:30 PM by EdwinvD

    Storing a date in SQLite


      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.