Inserting date in sqlite db using adobe air and javascript

Question

I am trying to insert a date value in sqlite db using air and javascript. The value gets inserted but when I try and view it, it says null.

Later I found that SQLite stores date using julian format. How to convert a javascript date object to julian format?

Hemanshu Bhojak · Accepted Answer · 2009-07-24 10:04:54Z

1

Adobe AIR does not support the JS date object. While inserting data I was using

stmt.parameters[":myDate"] = new Date();

This was inserting the date in the database but was not returning it in a useful format. I tried the following and it worked like charm.

stmt.parameters[":myDate"] = new window.runtime.Date();

answered Jul 24, 2009 at 10:04

Hemanshu Bhojak

17.3k19 gold badges51 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

simplyharsh · Accepted Answer · 2009-07-23 07:01:58Z

0

I got something.

Inserting the data in to SQLite:

 INSERT INTO <table> (<column>) VALUES (’2008-06-09 07:20:00′);

here, the important thing is - <column> data type should be DATETIME.

Fetching the data back from SQLite:

SELECT datetime(<column>) AS <variableName> FROM <table>;

answered Jul 23, 2009 at 7:01

simplyharsh

36.5k12 gold badges69 silver badges74 bronze badges