Skip to content
Advertisement

Tag: sqldatatypes

Making sense of date-time and datatypes in SQLite

I’m learning SQL and SQLite at the moment, and from what I understand, SQLite doesn’t support a datetime datatype. However, when I run the command PRAGMA table_info(Orders); it’s showing one column as being of type datetime. I’ve read that In SQLite, the datatype of a value is associated with the value itself, not with its container. taken from here https://www.sqlite.org/datatype3.html

Advertisement