HOW TO CONVERT MILITARY HOUR TO NORMAL HOUR

Database

HOW TO CONVERT MILITARY HOUR TO NORMAL HOUR

Hello,

Does anyone know how to convert a military hour to a normal hour with this FORMAT command in Teradata SQL syntax (FORMAT 'HH:MIBT' ) ?

For Ex:

13 to 1
14 to 2
15 to 3
and so on

Thanks,
mcateed