Re: How to convert time format from HH12 to HH24 in table

I asume you have the AM/PM indicator somewhere

so the you can do something like this

select to_char(to_date('11:13 PM','HH12:MI PM'),'HH24:MI') from dual;

Yu Dong wrote: Received on Fri Oct 09 1998 - 06:14:47 CEST