varchar2 format to AM/PM

[mars19301]

The course starting time is in a 24 hour field (varch2(4))that I must display as AM or PM as appropriate. Would somebody point me in the right direction? Thank you in advance for your help.

 

[SantaMufasa]

Mars,

Here is the technique:

select to_char(to_date('2215','hh24mi'),'hh:mi A.M.') from dual;

TO_CHAR(TO
----------
10:15 P.M.

Of course, instead of the literal that I used ('2215'), you would refer to the name of the VARCHAR2(4) column.

Let us know if this resolves your question.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]

 

[mars19301]

Perfect! Many thanks.

m