M mozaharul Active Member Licensed User Apr 1, 2008 #1 In the SQLite insert command the "insert into geo values(calender1.values)" save the date as ticks. But if I use " insert into geo values(date(calender1.values))" then it saves zero (0) in the database. Please help regards
In the SQLite insert command the "insert into geo values(calender1.values)" save the date as ticks. But if I use " insert into geo values(date(calender1.values))" then it saves zero (0) in the database. Please help regards
Erel Administrator Staff member Licensed User Apr 2, 2008 #2 Try: B4X: "insert into geo values('" & date(calender1.values) & "')"