Data insertion into audit table from base table.
859128May 3 2011 — edited May 4 2011There issue with time stamp in one column in base table & audit table as shown below.
I have one base table & audit table. Whenever there is some insertion/updation/deletion in base table records will be available in audit table.
In this issue in base table value for latest last_updated_date is 3/30/2007 7:44:10 PM, this value should be copied as it is to audit table to nlast_updated_date, but while copying there is some change in the time (3/30/2007 7:48:11 PM) .
There is a after trigger written to insert the data into audit table whenever there is insertion/updation/deletion in base table. I have checked the trigger and it is just picking the value in column & inserting into audit table without changing anything.
Please let me know if anyone knows the reason for this change while inserting to audit table.
Any help is highly appreciated.