jwzumwalt <jwzumw...@neatinfo.com> wrote: > Where can I find a complete list of Sqlite timezones. I Google searched > without success. > > i.e > hawaiin ?? > date_default_timezone_set('America/Los_Angeles'); // pacific timezone
date_default_timezone_set is not part of SQLite. You must be using some other library - possibly PHP: http://php.net/manual/en/function.date-default-timezone-set.php http://www.php.net/manual/en/timezones.php The examples you show appear to be coming from Olson database: http://www.iana.org/time-zones http://en.wikipedia.org/wiki/Tz_database http://en.wikipedia.org/wiki/List_of_tz_database_time_zones If so, Hawaiian time should be represented as Pacific/Honolulu -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users