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

Reply via email to