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?
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
