4 ms·
There are standard ANSI SQL DATE, TIME, TIMESTAMP and INTERVAL data types. SQLite is not truly standards compliant by missing these truly essential column typ
by lenkite 5y ago
There are standard ANSI SQL DATE, TIME, TIMESTAMP and INTERVAL data types.
SQLite is not truly standards compliant by missing these truly essential column types which make it deeply inconvenient for use in enterprise apps. And also for apps that need pluggable/switchable backend SQL storages.