Re: [sqlite] setting the timezone on windows xp
Thanks Doug. On Sat, Oct 25, 2008 at 11:48 AM, Doug <[EMAIL PROTECTED]> wrote: > Hi Jay -- > > I used to have a problem like this a few years back. I don't remember all > the hows and whys, but my apps call the following at start up and the > problems are gone: > > _tsetlocale(LC_ALL, _T("")); > _tzset(); > > HTH > > Doug > > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:sqlite-users- > > [EMAIL PROTECTED] On Behalf Of Jay Sprenkle > > Sent: Saturday, October 25, 2008 10:32 AM > > To: General Discussion of SQLite Database > > Subject: [sqlite] setting the timezone on windows xp > > > > Hello all, > > this isn't really an sqlite question but it tangentially touches on it. > > Please disregard it if it offends. > > > > I'm trying to write an atom feed exporter for my sqlite database and I > > need > > to export the utc time. My development box, windows xp, insists (both > > in C > > and in SQLite) that UTC is 10 hours different than localtime. I've > > clearly > > set the timezone to US CST in the control panel. I've also tried > > setting > > both the TZ and TIME_ZONE environment variables (CST6CDT). No luck. > > > > Any suggestions? > > ___ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- -- The PixAddixImage Collector suite: http://groups-beta.google.com/group/pixaddix SqliteImporter and SqliteReplicator: Command line utilities for Sqlite http://www.reddawn.net/~jsprenkl/Sqlite Cthulhu Bucks! http://www.cthulhubucks.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] setting the timezone on windows xp
Hi Jay -- I used to have a problem like this a few years back. I don't remember all the hows and whys, but my apps call the following at start up and the problems are gone: _tsetlocale(LC_ALL, _T("")); _tzset(); HTH Doug > -Original Message- > From: [EMAIL PROTECTED] [mailto:sqlite-users- > [EMAIL PROTECTED] On Behalf Of Jay Sprenkle > Sent: Saturday, October 25, 2008 10:32 AM > To: General Discussion of SQLite Database > Subject: [sqlite] setting the timezone on windows xp > > Hello all, > this isn't really an sqlite question but it tangentially touches on it. > Please disregard it if it offends. > > I'm trying to write an atom feed exporter for my sqlite database and I > need > to export the utc time. My development box, windows xp, insists (both > in C > and in SQLite) that UTC is 10 hours different than localtime. I've > clearly > set the timezone to US CST in the control panel. I've also tried > setting > both the TZ and TIME_ZONE environment variables (CST6CDT). No luck. > > Any suggestions? > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] setting the timezone on windows xp
Hello all, this isn't really an sqlite question but it tangentially touches on it. Please disregard it if it offends. I'm trying to write an atom feed exporter for my sqlite database and I need to export the utc time. My development box, windows xp, insists (both in C and in SQLite) that UTC is 10 hours different than localtime. I've clearly set the timezone to US CST in the control panel. I've also tried setting both the TZ and TIME_ZONE environment variables (CST6CDT). No luck. Any suggestions? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users