how to convert negative value in 0
Taj.Apr 28 2010 — edited Apr 28 2010dear all,
there is a query
column
due date
late fee rate
value of column
1. due date ======= 11-may-10
2. late fee rate ===== 5
select trunc(sysdate) - trunc(due_date) * late_fee_rate from dual;
as per the above query and value i am getting negative value because due date is on 11-may-10.
is there any function or something which convert negative value in '0'.