Tito Ciuro wrote:
Hello,
The only reference I see about timezone support in SQLite is in this
example:
Compute the date and time given a unix timestamp 1092941466, and
compensate for your local timezone.
SELECT datetime(1092941466, 'unixepoch', 'localtime');
I found this here:
http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions
Where can I find more info?
Timezones are enormously complicated, mostly because daylight saving
time rules. Every locale does it a little bit differently. And the
rules change from year to year.
So, no, I am not going to fight that battle. Doing timezones correctly
could easily double the size of the library. If you need timezones,
link in a separate library that focuses on timezones. SQLite is going
to stay focused on storing and retrieving data.
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565