Okay, I give up. I've been searching for a while now. I've found a number of discussions about how CURRENT_DATE returns the date in UTC, and that it can be converted to local time. But I've yet to find one article that clearly states how one might do this.
I would love to have a table column default to the current date, but I want it to be the date where the computer is located, rather than some far off place. Can anyone tell me if this is possible? Thanks. -- View this message in context: http://www.nabble.com/Default-Column-Value-to-Local-Time-tp19263208p19263208.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list firstname.lastname@example.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users