date format in oracle database

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

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Dear Sahana

Date trans should work.

Input should be yyyyMMdd hh.mm.ss if you are using a proxy

Output dd-MMM-yy hh.mm.ss

Regards

Monika

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Ask a Question

Top Q&A Solution Authors

User

Count