This discussion is archived
3 Replies Latest reply: Nov 18, 2012 7:36 AM by roots RSS

How to get/display  time with minutes in a test item

roots Newbie
Currently Being Moderated
Dear experts,
Forms [32 Bit] Version (Production)
Oracle Database 10g Express Edition Release - Production
Oracle Toolkit Version (Production)
PL/SQL Version (Production)
I've the following requirements.

In my form, there are three text items and one save button.

Text items named as

No_of_days --> Number data type
(user will enter number of days)

hours_limit --> Char data type with format mask (HH:MI);
(user will enter hours with minutes)

Upto_date_time --> date data type;
this field calculated as (No_of_days+hours_limit+sysdate)

User will enter No_of_days or hours_limit:

Based on the values I've to calculate Upto_date_time

Here is the problem:

1) If user doesn't enter hours_limit I want to show default time as " 04:00 PM"

2) If user enter hours_limit field we should allow them to enter in the following format
"HH24:MI" format;

what whould be suitable data type for hours_limit field..
I tried with char and i've set the format mask as ,

But I'm geeting the error

"FRM-50027:Invalid format mask for given datatype"

Please help to solve this problem,




  • Correct Answers - 10 points
  • Helpful Answers - 5 points