'Oracle ApexCreate Time field HH:MM

I am having difficulty with a duration field on my form/table.

The users need to indicate in HH:MM how long a meeting took.

  1. What datatype should the column have in the Table. Currently it is TIMESTAMP

  2. How can I make the field have an input mask of 'HH:MM'. What I would like is for the user to be able to type '0130' and the field format it to '01:30' immediately.

Reporting on these times is required so I assume that entering the data as VARCHAR will not help.

oracle-apex


Solution 1:[1]

If quarters are enough..

item: text field with autocomplete

SELECT ss|| ':' || dd ss_dd
FROM
 (SELECT to_char(trunc(sysdate)+(level - 1)/ 24,'HH24')ss
  FROM dual CONNECT BY level <= 24),
 (SELECT lpad(mod(15 * level, 60), 2, '0') dd
  FROM dual CONNECT BY level <= 4)

enter image description here

Solution 2:[2]

APEX 4.2: Just to shed some light for any future viewings; now there are loads of Apex plugins for the purpose of picking Date/Time or both returning variations of date time formats as you would required. For e.g. as in your case HH:MM or HH24:MI.

I have personally used TimePicker plugin from http://www.apex-plugin.com which I have no problem in recommending.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Oguen
Solution 2 D777Stack

Related Questions