You want to convert AM to PM? What about PM (no change, to AM same day,
to AM next_day)?

why not simply

sysdate+0.5

?

KAzi

Mason John wrote:
> 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
>
>
>
>
> ---------------------------------------------------------------------
> 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