Yes, I understand that beyond integer, float, and chars, there are no
further "types", but I was just questioning whether current_timestamp
formats what it stores in a specific manor, or, if it has some dealings
with the locale of the system its executed on. You've answered the
question. Thanks.
There is no "DATE" type in SQLite. The current_timestamp is a TEXT value
equivalent to datetime('now') which returns an ISO formatted datetime string in
UTC (-MM-DD HH:MM:SS).
-Ursprüngliche Nachricht-
Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im
Auftra
2 matches
Mail list logo
