TIMESTAMPs with SQLite

Might be of interest: Handling date & timestamps in SQLLITE

storing dates as TEXT as ISO8601 strings (“YYYY-MM-DD HH:MM:SS.SSS”) seems to have addressed a similar issue to what you describe.

1 Like