i am using oracle forms 6i on windows 7
Database:oracle database 10g
i want to store the data of workers free time in hours and minutes.
So i have created my table structure as
SMALL_PCS_WEIGHT NUMBER(5,2) FREE_TIME INTERVAL DAY(6) TO SECOND(6)
But forms does not accept this data type.
Edited by: kaminanikamini on Apr 30, 2013 1:50 AM
I suggest you store it as decimal hours in a normal number field number(6,3) or similar. So 1.5 would be an hour and a half.
Then use a self written function to split it out to hours and minutes when you need to display it.