| date fields calculation [message #371405] |
Fri, 13 October 2000 08:22 |
FELIX L. BOWMAN
Messages: 2
Registered: October 2000
|
Junior Member |
|
|
" Hi, my name is Felix Bowman. I am `NEW` to oracle and I`m looking for a routine (Or the possible correction of this script) to calculate the difference between two date fields to obtain the exact day(s), month(s),yr(s) as separate fields and be able to execute any further calculations based on these values.
I designed a script on my own using forms 2.1 and oracle 7.3 but, sometimes the resulting fields aren`t exact , the reason ? . Attached to this message is the script itself as a way to illustrate you of what I am talking about .
THXS IN ADVANCE,
Felix Bowman
script :
B1.F1 = `18-NOV-63`;
B1.F2 = `05-SEP-00`;
select (:B1.F2 - Add_months(:B1.F1,floor(months_between(:B1.F2, :B1.F1)))) + 1 days,
FLOOR(FLOOR(MONTHS_BETWEEN(:B1.F2, :B1.F1))/12) years,
FLOOR(MONTHS_BETWEEN(:B1.F2, :B1.F1)) - FLOOR(FLOOR(MONTHS_BETWEEN(:B1.F2, :B1.F1))/12)*12 months
into :B1.Days, :B1.years, :B1.Months
from dual;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
