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
Discussion posts and replies are publicly visible
check mili function in Appian:
docs.appian.com/.../fnc_date_and_time_milli.html
And the milli() function would do ... what exactly?
In my case it gave me proper milliseconds value same as in DB
I understand. So it seems to be a "issue" of the way how Appian displays the data, but there is nothing modified somewhere. I think this insight is a good answer to the initial question.
Worth to check on SQL server. I'm using this against Oracle db.
As workaround you can use SP (type cast the field to varchar if needed) to get the precise value.
Hi,
Is there any solution for this issue, I am facing the same problem.
Hi Meme02 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
... actually, there is no issue. As discussed here, it is just the way how Appian displays that value by default. And if you do not like the default, feel free to format the value in a different way.