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).
Results 1 to 3 of 3
Thread: Formatting a char field to date
Click Here to Expand Forum to Full Width