On Mon, 20 Oct 2008 10:46:41 -0700 (PDT), jonwood <[EMAIL PROTECTED]> wrote in General Discussion of SQLite Database <sqlite-users@sqlite.org>:
> >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? Instead of using DEFAULT you can create an ON INSERT trigger that sets any column to any value you wish. Or you could modify the SQLite source to suit your taste. >Thanks. -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users