I've got a table in database which consists of start date and finish date. Ok now what I have to do is the fact that database ought to be checked once during the night checking all finish dates. if today is yesterday the finish date, i quickly can perform java class which will send the e-mail notification saying membership will expire. I'm using oracle database and java (jsf) as development language.
My date saved within the table is within my preferred format i.e. MM/DD/YYYY.