plsql - How to keep the military format when converting string to timestap in Oracle? -

this code:

 l_ts := to_timestamp((d || ' 13:00:00'), 'dd.mm.yyyy:hh24:mi:ss');   u_ts := to_timestamp((d || ' 17:00:00'), 'dd.mm.yyyy:hh24:mi:ss'); 

i keep getting:

26-may-13 01.00.00.000000 pm 26-may-13 05.00.00.000000 pm 

i want:

26-may-13 13.00.00.000000 pm 26-may-13 17.00.00.000000 pm 

i.e. 13 , 17 instead of 1 , 5.

thanks hrlping

you converting string date, , display date directly. when way, output formatted string internally , depends on session locale settings.

if want date in format want, should use to_char function format date string when need displayed user. to_char can use format models date in format wish (try in sql server... ;).

consider script:

set serveroutput on; declare      l_ts timestamp; begin     -- here date string     l_ts := to_timestamp(('01.01.2013' || ' 13:00:00'), 'dd.mm.yyyy:hh24:mi:ss');      -- here string representation of date.      -- representation depends on session settings,      -- , should not relayed upon.     dbms_output.put_line(l_ts);     -- examples how can display date string in way need     dbms_output.put_line(to_char(l_ts,'yyyy-mm-dd hh24:mi:ss'));     dbms_output.put_line(to_char(l_ts,'yyyy-mm-dd hh12:mi:ss am')); end; 

hope clear issue. :)