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.