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 (YYYY-MM-DD HH:MM:SS).
-----Ursprüngliche Nachricht-----
Von: sqlite-users [mailto:[email protected]] Im
Auftrag von Stephen Chrzanowski
Gesendet: Dienstag, 17. Oktober 2017 07:59
An: General Discussion of SQLite Database <[email protected]>
Betreff: [EXTERNAL] [sqlite] current_timestamp locale
Does SQLite go by users locale to insert date/time information into a row, or
is it a very specific format when using current_timestamp as a default value?
I don't want to go start monkeying with my system settings to find out, so,
relying on those with experience.
Thanks
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
___________________________________________
Gunter Hick | Software Engineer | Scientific Games International GmbH |
Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 | (O) +43
1 80100 - 0
May be privileged. May be confidential. Please delete if not the addressee.
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
