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