Get datetime fields in sql.

[ambg]

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]

SQLite doesn't have a special date type. You can save the dates as a string or number.

 

[timo]

Have a look at here:
Datatypes In SQLite Version 3

 

[ambg]

Thanks. Great help.