Hi, How are timezones best handled? Since dates are stored in GMT, when I go to display them, I need to add/subtract the timezone. That's not too hard when I can just store the timezone as "-5" for EST. When I'm providing a date to query on, I would have to apply the reverse of the timezone, "+5", to normalize it to GMT.
That kinda sucks :( I come from PostgreSQL, so I normally set at the connection level the timezone and PG handles all the conversions. Does SQLite have a similar feature? Is there a standard way to handle this? Thanks, -will _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users