Calculating overdue fine

[CaesarII]

Hello all, I’m using oracle 10g forms builder to create dvd rental system, the problem I’m having is calculating the overdue fine. I already have the date the dvd is rented out, $$date$$, and the date due, sysdate + 7 (i.e. 7 days after date out), i however as perversely stated have no idea how to calculate the fine (which is charged at £2.00 a day) and any help would be appreciated. Thanks, CaesarII

[niche]

It would be an if statement: http://w3schools.com/php/php_if_else.asp However, they're not very perverse. lol

[CaesarII]

whilst helpfull and gave me other ideas it did not help me solve my original problem, thanks though

[niche]

How far have you got on your if statement? Please post what you have.

[CaesarII]

This is what i have so far; if (date returned < date out) { SELECT DATEDIFF (day,'RENTAL_CARD.TEXT_ITEM_DATE_RETURNED',''RENTAL_CARD.TEXT_ITEM_DATE_RETURNED') AS DiffDate*2; };

[niche]

I forgot this is in the sql forum so the if becomes a WHERE. So, your code would look something like this:

"UPDATE table SET fine = 2 WHERE TIMESTAMP(NOW()) BETWEEN TIMESTAMP(rental_date) AND TIMESTAMP(WEEK,1,rental_date) AND customer_id = '$customer_id_selected" 

Edited August 7, 2012 by niche

[CaesarII]

Changing the formula to fit my precise table and field names is going well (however oracle doesn’t seem to like timestamp), I’m off home for the evening and I’ll continue more tomorrow

[niche]

The sql I know is mysql. Perhaps, someone else can help that knows the oracle version.