This content has been marked as final. Show 3 replies
the above calculation is wrong as it should be
you want to devide sysdate with 12 as there is no any division or multiplication with
date data types.
you can do addition or subtraction with date data types which will give your the corresponding next and previous dates.
Actually i could not understood your 11 month and 9 days extraction from sysdate/12
can you elaborate it.
Your are rite vansul...its mah typing mistake or paste mistake :)
anyhow my scenario is calculation i have some employee vacation calculation based on the below formula in MS access so im converting here in oracle forms 6i.
my requirement is with the joinning date.
SQL> select 30/12*11.9 from dual; 30/12*11.9 ---------- 29.75 SQL> select 30/12*12 from dual; 30/12*12 --------- 30 here 30days in 12months
emp_join_date 01-01-2005 (Example)
in my formula the calculation should be 30/12*12 check with sysdate and number of months from emp_join_date. it should count number of months till today date from the joining date.
Maybe you can use MONTHS_BETWEEN instead.