This content has been marked as final. Show 3 replies
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.1 person found this helpful
Then use a self written function to split it out to hours and minutes when you need to display it.
Thanks for replying.
But i want to store hours and mins like for 2 hours 30 mins
But i want to store hours and mins like for 2 hours 30 mins2:30>
Then store it as a VARCHAR2(5). Either way, you're not going to be able to use the INTERVAL data type because Forms 6 does not support this data type.