thank you very much !
On Feb 17, 4:09 pm, Oblygre <[email protected]> wrote: > 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
