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

Oracle LazyDBA home page