Skip to main content
A
anushris738
New Participant
September 4, 2023
Question

Database DateTime Vs Appian DateTime ?

  • September 4, 2023
  • 9 replies
  • 4 views

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
jakubf0002
Known Participant
September 5, 2023

check mili function in Appian:

docs.appian.com/.../fnc_date_and_time_milli.html

stefanhelzle0001
stefanhelzle0001
Brainy
September 5, 2023

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

jakubf0002
jakubf0002
Known Participant
September 5, 2023

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

G
gangamadhur0002
New Participant
October 11, 2023

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

nguyenb6532
nguyenb6532
Known Participant
October 30, 2024

Hi,

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

karumurua531442
karumurua531442
Participating Frequently
October 30, 2024

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 

Terms & ConditionsAccessibility statement