Skip to Content
0
Apr 05, 2012 at 08:39 AM

date format in oracle database

99 Views

hi all,

I have to insert date and time to oracle db from pi and it has a format

mm/dd/yyyy hh:mm:ss am

or

mm/dd/yyyy hh:mm:ss pm

how can i achieve this in PI .how can i get time in 12 hr format...

thanks,

sahana