Post reply

How to retrieve last modified timestamp?

  • June 16, 2004 at 3:43 am

    #84816

    Hi,

    Is there any way to get the last modified time stamp of any table or database without storing the timestamp in table explicitly?

    I would like to know when the table/database (any row / field) modified.

    Advance Thanks,

    Ramana

  • June 17, 2004 at 7:52 am

    #510840

    I have some tables that require monitoring all updates made to them. I put a trigger on the table so that whenever an action occurs the data is written to a history table... including the column modified, old value, new value, user, and date/time.

    If this helps and you want an example, let me know.  SMV

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply