Subject | Display rows that have been updated recently |
---|---|
Author | Josh Aguilar |
Post date | 2011-07-29T07:47:46Z |
Hi Guys
This might sound like a really idiotic newbie question, but I'm gonna
ask anyway.
Is there a way to find out if a row has been updated recently? Like a
hidden time stamp somewhere?
What I'm trying to do is do a select query on a table and display rows
that have been changed or added in the last hour or so. Unfortunately I
can't add another date/time field to the table because there's and
existing application that's dependent on the structure so I can't change it.
Any thoughts would be appreciated.
Cheers!
Josh
[Non-text portions of this message have been removed]
This might sound like a really idiotic newbie question, but I'm gonna
ask anyway.
Is there a way to find out if a row has been updated recently? Like a
hidden time stamp somewhere?
What I'm trying to do is do a select query on a table and display rows
that have been changed or added in the last hour or so. Unfortunately I
can't add another date/time field to the table because there's and
existing application that's dependent on the structure so I can't change it.
Any thoughts would be appreciated.
Cheers!
Josh
[Non-text portions of this message have been removed]