Skip to main content
New Participant
Sep 4, 2023 6:22 AM UTC
Question

Database DateTime Vs Appian DateTime ?

HI All ,

I have ModifiedDt stored in MSSQL Server with DateTime format , when i query the same Date in Appian it shows a slight difference in millisecond . I am guessing Appian round's off this value ? Is this correct ? Does anybody else observed this issue ?

Examples below -

Database

Appian

9 replies

jakubf0002
Known Participant
Sep 5, 2023 7:42 AM UTC
stefanhelzle0001
Brainy
Sep 5, 2023 7:52 AM UTC

And the milli() function would do ... what exactly?

jakubf0002
Known Participant
Sep 5, 2023 8:23 AM UTC

In my case it gave me proper milliseconds value same as in DB

New Participant
Oct 11, 2023 3:43 AM UTC

As workaround you can use SP (type cast the field to varchar if needed) to get the precise value.

nguyenb6532
Known Participant
Oct 30, 2024 1:21 AM UTC

Hi,

Is there any solution for this issue, I am facing the same problem.

karumurua531442
Participating Frequently
Oct 30, 2024 1:46 AM UTC

Hi [mention:292bb21fb8eb45c2ae8bc9d5cfd8c374:e9ed411860ed4f2ba0265705b8793d05]  could you please raise a new thread for your issue and give us more context on the issue please that would help us to debug the issue