current_timestamp locale

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

current_timestamp locale

Stephen Chrzanowski
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
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: [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 (YYYY-MM-DD HH:MM:SS).

-----Urspr√ľngliche Nachricht-----
Von: sqlite-users [mailto:[hidden email]] Im Auftrag von Stephen Chrzanowski
Gesendet: Dienstag, 17. Oktober 2017 07:59
An: General Discussion of SQLite Database <[hidden email]>
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
[hidden email]
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
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: [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 <[hidden email]> 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:[hidden email]]
> 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
> [hidden email]
> 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
> [hidden email]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users