Select translate(to_char(sysdate, 'DD/MM/YYYY HH:MI:SS AM'), 'A', 'P')
from dual;


-----Original Message-----
From: Sanju Gupta
[mailto:oracledba-ezmlmshield-x28410644.[Email address protected]
Sent: Saturday, March 29, 2008 1:12 AM
To: LazyDBA Discussion
Subject: time format help



hi all

i want to simply convert the time from am to pm.

for example

given -- '29/03/2008 4:12:35 am'

needed output --'29/03/2008 4:12:35 pm'

thanks in advance
sanju


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page