Re: [sqlite] [EXTERNAL] current_timestamp locale

[Stephen Chrzanowski]

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  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 (-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.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

Re: [sqlite] [EXTERNAL] current_timestamp locale

[Hick Gunter]

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 
Auftrag von Stephen Chrzanowski
Gesendet: Dienstag, 17. Oktober 2017 07:59
An: General Discussion of SQLite Database 
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