Derrell Lipman wrote: > > I think this is the page you're looking for: > http://www.sqlite.org/lang_datefunc.html > > In particular, a query that returns the current time in the local (to > sqlite) time zone is: > SELECT datetime('now', 'localtime'); > or for just the date: > SELECT date('now', 'localtime'); >
Well, okay. That's one of the articles I did see. Right now, I'm having two issues: 1. I'm not sure how to use those functions. You've gave me some examples, which I appreciate. But your examples don't work with columns. Perhaps the first argument needs to be my column name? 2. I'm currently using a default value of CURRENT_DATE in several tables. At this stage, it would be a lot less work if I could continue to not explictly specify the initial value for these columns. Can anyone confirm that this is simply not possible to do this with the local time? (I want the value actually stored in the database to be local time, and not to simply convert the UTC value every time it is used.) Thanks! -- View this message in context: http://www.nabble.com/Default-Column-Value-to-Local-Time-tp19263208p19263339.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
