0 Replies Latest reply on Apr 12, 2019 10:55 AM by juliojgs

    How would you store an interval type from forms 11g?

    juliojgs

      Hi, this is forms 11g.

      I have to store an interval (hours and minutes) in database, and manage it from a form.

      The db table is still undefined, so it doesnt have to be an actual interval oracle datatype. It could also be number(4,2), for example (99 hours length is more than enough).

       

      How would yo do this? char control item with a format mask like 90":"00 and convert it to hours number in WVR and back in post-query?

       

      Thanks.