Just as any other data....
Example:
db.execute("insert into table (<your_field>) values (?)",
[formatdatetime()]);
//Some functions to make a proper date/time
function formatdate() {
var today=new Date();
var year=today.getFullYear();
var month=checkTime(today.getMonth()+1);
var day=checkTime(today.getDate());
return year+'-'+month+'-'+day;
}
function formatdatetime() {
var today=new Date();
var h=checkTime(today.getHours());
var m=checkTime(today.getMinutes());
var s=checkTime(today.getSeconds());
//document.getElementById('txt').innerHTML=h+":"+m+":"+s;
return formatdate()+" "+h+":"+m+":"+s;
}
function checkTime(i)
{
if (i<10)
{
i="0" + i;
}
return i;
}
On Feb 17, 8:47 am, Alex <[email protected]> wrote:
> Hi all,
>
> how to store datetime data in gears database (sqlite3) ?
>
> Thank you !
>
> Alex
