on 06-16-2014 8:29 PM
I'm using powerbuilder 12.5 to send data to Orcale 11g. In the develpoment env. the timestamp will update in Orcale. In run time the timestamp will not update. What am I missing in the run time env. ? Thanks Randy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Randy,
Can you pleae elaborate, what timestamp you mean? Where exactly? Is it in some views or the timestamp of last DDL for any object,etc.?
Regards,
János
Hello Janos
The Timestamp is a data type in Oracle. I have a table with a Timestamp data type instead of a datetime data type.
Format would look like this “26-MAR-14 02.37.03.000000000” the last being the milliseconds.
When I update through the PowerBuilder development it looks correct. “26-MAR-14 02.37.03.129000000 PM”
When I update through the PowerBuilder exe or runtime executable it looks like this. “26-MAR-14 02.37.03.000000000 PM”
The millisecond dose not update.
Thanks Randy
Hi Randy,
I think this behaviour is caused directly by PowerBuilder. Did you asked their support already?
I fear, I can not help you further.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.