Hi,

The time is stored in a varchar2 field as "1603", I would like to format it to display "4:03pm" in the output.

I used the to_date function and I got this error:
(ORA-01849: hour must be between 1 and 12).

Please help.

Thanks

Mo