Bill McCormick wrote, On 1/27/2012 12:12 PM:
I have a date stored in a numeric field like this: 2012-01-27 16:47:50.I want to update the date using the date function, like this: update table set TIME_STAMP = date('TIME_STAMP', '+ 2 years'); Reference: http://www.sqlite.org/lang_datefunc.html I also tried this: update table set TIME_STAMP = date(TIME_STAMP, '+ 2 years'); Neither form works correctly, it just clears the field. What am I doing wrong?
Sorry, I got it ... update table set TIME_STAMP = date(TIME_STAMP, '+2 years'); Silly space _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
