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
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
