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
thanks all,i solved the issue...
no need of udf or complex mapping
it can be achieved in TO_DATE() function passing current date as MM/dd/yyyy HH:mm:ss a
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
and you can also use the copyValue finction instead of useOneasMany make it less complicated .
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.