SQLite and dates

[TIMAI2]

Also:

SQLite Date & Time - How To Handle Date and Time in SQLite

and in case you are using the SimpleSQLite extension, see this:

[FREE] SimpleSqlite - an extension for working with SQLite Databases

Figured it out. SQLite and/or the extension, is treating your time column integer values as date/times (unixepoch), so something funny happens to them when handled by the extension and imported into AI2. You can CAST an integer to a string, then everything is OK. Change: SELECT MAX(time) FROM lastTimestamp to SELECT CAST(MAX(time) as TEXT) FROM lastTimestamp; SimpleSqlite returns the value in a list, so get the first item, then apply the value to your query [blocks (10)] Note1: You cou…

(you can read the posts above this to fully understand what the issue was)