Thanks all for the inputs. The date field is a datetime field. Ok what i had done is created an update trigger which captures suser_sname and app_name and i can...

This table is read by other processes but not get modified only by front end application. The issue is only that date column has this issue and the auto reverting...