On 2017-09-25 08:19:52, "R Smith" <rsm...@rsweb.co.za> wrote:
On 2017/09/25 10:12 AM, David Wellman wrote:
C - Storing a string with a date or date and time, typically the
standard form is ISO8601 which looks like 'YYYY-MM-DDTHH:NN:SS.MSS
+ZZ:ZZ' with the T optionally being a space and the + could be + or -
to indicate offset (Zulu time) etc. Some parts are optional, there is a
good argument to not store Zulu time (offsets) but revert to UTC and
let the displaying app format the time to whatever time-frame the user
expects (much like Unix timestamps), so most actual stored dates end up
as simply 'YYYY-MM-DD HH:NN:SS' or even just 'YYYY-MM-DD' if not
interested in the time.
It's worth noting that the CURRENT_TIMESTAMP keyword uses "YYYY-MM-DD
HH:MM:SS" format, and implied UTC.
--
J. King
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
