On 12 Aug 2019, at 1:27pm, Tim Streater <t...@clothears.org.uk> wrote:

> I don't expect to do that with SQL. My "seconds since the epoch" is based on 
> converting any particular time to GMT and storing that. That number is then 
> converted to a date/time with TZ info for display.

I'm with Tim.  Storing the time zone with the timestamp is a different matter.  
It leads to problems with sorting and searching.  We can discuss it, but it 
doesn't belong in this thread.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to