Hi Team,
Greetings!
It was observed that when a DateTime type argument is sent to stored procedure call from PowerBuilder, it is getting modified for PowerServer deployed apps.
For example,
actual value=05-02-2022 10:10:10.010, 05-02-2022 10:10:10.075
sent value=05-02-2022 10:10:10.100, 05-02-2022 10:10:10.750
The leading zero is getting dropped and instead appended at last.
Using Sybase ASE ODBC connections for our apps.
Maybe related to bug https://www.appeon.com/standardsupport/track/view?id=6353
Kindly have a look.
Thanks,
Nilotpal
Greetings!
Thanks for looking into.
Will open a ticket for the same.
Thanks,
Nilotpal
Greetings!
Marking this thread as resolved since a ticket for the same has been opened.
https://www.appeon.com/standardsupport/track/view?id=8325
Workaround: Pass the DateTime value with milliseconds as String converted value(using the String function with display format argument) to the stored procedure.
Applicable for PowerServer 2021 and Sybase ASE 16 ODBC connections.
Thanks,
Nilotpal