Read date/time in an sqlite data base file

[Gintaras]

After posting I noticed

OK, I am happy that the following worked perfectly too!

db3.Exec("SELECT date(rec), time(rec) FROM tbx" ar)

and deleted the post. It was similar code. Not tested, I don't know is it correct.

Macro Macro3016

Code:

Copy      Help

Sqlite db3.Open(dbfile)
ARRAY(str) ar; int r
db3.Exec("SELECT date(dateColumnName), time(dateColumnName) FROM mydataf" ar)
for r 0 ar.len ;;for each row
,out "%s %s" ar[0 r] ar[1 r]