Read date/time in an sqlite data base file

[Gintaras]

Also try SQLite functions in your SQL string.

https://www.sqlite.org/lang_datefunc.html

https://www.sqlitetutorial.net/sqlite-date/

 

Code:

Copy      Help

SELECT date(d1), time(d1) FROM datetime_real;