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 B4X founder Staff member Licensed User Longtime User Apr 2, 2008 #2 Try: B4X: "insert into geo values('" & date(calender1.values) & "')"