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.