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
As workaround you can use SP (type cast the field to varchar if needed) to get the precise value.