I am using SQLite for my cgi application, however the timezone I am was not the same as those of the shared server these things are running on. Can One set my timezone in some way in SQLite and so i don't have to screw up my application as time passes conversions and that i may use such things as NOW() during my SQL? Otherwise: what exactly are my other available choices?
SQLite does not have the means to set the bond time zone since it is specific towards embedded database uses--anything you use to modify your C library localtime() output should work with SQLite. This works best for me on MacOS:
$ TZ=America/New_You are able to sqlite3 dbfile "choose datetime('now','localtime')" 2010-01-06 09:53:28 $ TZ=America/Los_Angeles sqlite3 dbfile "choose datetime('now','localtime')" 2010-01-06 06:53:41