How to insert Hours, Minutes into table
How to insert Hours, Minutes into table I am getting an error Hour between 1 and 12 below is my code
PACTUALOUTTME := TO_DATE('05:00 PM','HH:MI PM');
PROUNDEDINTIME := TO_DATE('09:05 AM','HH:MI AM');
PROUNDEDOUTTIME := TO_DATE('04:12 PM','HH:MI PM');
PHRSWORKED := TO_DATE('08:05','HH:MI');
**PLATE := TO_DATE('00:12','HH:MI');**
**PLEFTEARLY := TO_DATE('00:05','HH:MI');**
POT := TO_DATE('01:00','HH:MI');
PCOMMENTS := 'Left Early';
PREMARKS := 'Permission';
PCREATEDBY := '101';
I want to insert hours along with minutes and only minutes, I have used DATE datatype for the above date and time columns
I am thinking that the highlighted are effecting the error any help please