|
|
|
|
|
|
by fushihara
74 days ago
|
|
|
I wish SQLite would add a bool type and proper date/time types. Is there really no plan to add them? For bool, it could just be an alias of a numeric type.
Something equivalent to number check(col = 0 or col = 1) would be perfectly fine. Date/time handling is pretty weak.
Having to store values as GMT text is just inconvenient. When retrieving values in Node.js, I ended up using new Date(val), which caused the classic bug where a GMT-stored value gets interpreted in the local timezone. The correct approach was new Date(val + ".Z"), but I really don’t want to deal with that kind of hassle anymore. |
|
|