Milliseconds not captured
- How-to
- Yasir Masood
- PowerBuilder
- Sunday, 28 May 2023 07:54 PM UTC
Hello,
We are using PB 2017 R3 Build 1858 with SQL Server 2018. I am not sure if this is a bug or a settings issue.
In the PB application when I access a SQL Server datetime field using a datetime variable, milliseconds are missing.
I used both datetime and datetime2 datatype in the SQL Server. But it doesn't work in PB.
The result from SQL Server is 2023-05-28 14:40:48.957 2023-05-28 14:40:48.9566667
And the result from PB is 2023-05-28 14:40:48 2023-05-28 14:40:48
I would appreciate your help.
Thanks
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.