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. :]
On Tue, Oct 17, 2017 at 2:34 AM, Hick Gunter <h...@scigames.at> wrote: > 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:sqlite-users-boun...@mailinglists.sqlite.org] > Im Auftrag von Stephen Chrzanowski > Gesendet: Dienstag, 17. Oktober 2017 07:59 > An: General Discussion of SQLite Database <sqlite-users@mailinglists. > sqlite.org> > 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 > sqlite-users@mailinglists.sqlite.org > 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 > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users