Hi folks I have a table with name, date in format DD.MM.YYYY.
name expiry date example CA 04.05.2013 example Sub-CA 01.09.2012 I need to something like this (I try to explain in pseudo code) if SYSDATE (current date) minus 6 months > $expiry date print OK else print NOK with $name and $expiry date I know this is possible with Oracle. How to do this in sqlite? cheers Sven _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users