On Oct 20, 2008, at 1:46 PM, jonwood wrote: > > Greetings, > > Okay, I understand that the designer of SQLite felt it was important > that > fields with a default value of CURRENT_DATE should be initialized to > the > current date in a DIFFERENT time zone. Setting aside for now that > I've read > all the reasons for this and am very much against the decision, I > have the > following question. > > Is there ANY way to override this behavior? Or must I simply > initialize all > such fields explicity if I would like to set it to the current date > in my > particular time zone?
CREATE TABLE whatever( .... timestamp DATE DEFAULT (datetime('now','localtime')), ... ); > > > Thanks. > -- > View this message in context: > http://www.nabble.com/CURRENT_DATE-Behavior-tp20075044p20075044.html > Sent from the SQLite mailing list archive at Nabble.com. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users D. Richard Hipp [EMAIL PROTECTED] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users