Read date/time in an sqlite data base file

[ssimop]

Dear Gintaras,

Many thanks for your reply too. Since I am not familiar with Sqlite, I would appreciate your assistance in getting this date/time information. I read the database using :
Function sqllt2Code: Copy      Help

Code:

Copy      Help

Sqlite db3.Open(dbfile)
ARRAY(str) ar; int r
db3.Exec("SELECT * FROM mydataf" ar)
for r 0 ar.len ;;for each row
,out "%-10s %s %s %s %s %s %s %s %s %s %s" ar[0 r] ar[1 r] ar[2 r] ar[3 r] ar[4 r] ar[8 r] ar[9 r] ar[10 r] ar[10 r]

The date/time real information is in element ar[10 r] and the string contained is "2459067.10928241".

Will you please use this example with the SELECT statement that you suggested?

Many thanks!

---

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

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

Best regards!