sqlite: calculating with dates - compare current date minus 6 months with stored record

Linux and Unix-Like UNIX and Linux Applications
1

Hi

I have a table with name, date in format DD.MM.YYYY.

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?