SQLite Forum

Proposed slightly-incompatible change to date-time functions
> SQLite could take times that just happen to be exactly at noon, and thus equal to an integer, and store it in the database as an integer as a form of compression

SQLite does indeed do this.  But it also converts the integer back into a floating
point number as it reads it back off the disk, so by the time it gets to the
date/time SQL functions, it is a REAL again.

> Maybe adding an 'Auto' modifier

That's a good idea. I'll consider that.

Recognize that all of this discussion is for 3.38.0 or later.  This is not
a change that is being considered for the upcoming 3.37.0 release.