1

I have a SQL trigger which adds the old value ,new value and time of update for column based on update, insert, update or delete.

To update the time we used SYSDATEand inserted record from trigger. This trigger was working fine for a long time. Few weeks back the server is upgraded to Exadata from 11g and now are experiencing some issues. The column inserted by SYSDATE is expected to update GMT time. But only in some cases it does insert central time and this behavior is intermittent. We also tried updating the table from same machine and experienced the same issue. So now we suspect it may be Exadata upgrade, but we are not sure. So does anyone has experienced similar issue or have any idea why this is happening.

1
  • SYSDATE uses the Linux boxes timezone. I suspect the timezone on one of the exadata blades is incorrect.
    – Philᵀᴹ
    Commented Feb 21, 2016 at 16:36

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.