Read date/time in an sqlite data base file

[ssimop]

Dear Kevin,

Thank you so much! Actually it is Gregorian (Julian Date) and your routine worked absolutely perfectly! Best Regards!

---

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 sqllt2

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!