A ambg Member Licensed User Longtime User Mar 20, 2012 #1 Hi, I use this code for retrieve fields from sql databases: dim cur as Cursor Cur=mysql.ExecQuery("Select * from table") I can retrieve strings and numeric values: cur.GetString("FieldName") cur.GetInt("FieldName") But , how do i can get a date field? Thanks,
Hi, I use this code for retrieve fields from sql databases: dim cur as Cursor Cur=mysql.ExecQuery("Select * from table") I can retrieve strings and numeric values: cur.GetString("FieldName") cur.GetInt("FieldName") But , how do i can get a date field? Thanks,
Erel B4X founder Staff member Licensed User Longtime User Mar 20, 2012 #2 SQLite doesn't have a special date type. You can save the dates as a string or number. Upvote 0
T timo Active Member Licensed User Longtime User Mar 20, 2012 #3 Have a look at here: Datatypes In SQLite Version 3 Last edited: Mar 20, 2012 Upvote 0