Hi guys,

This might be simplest thing, but I am newbie to databases.

I need to find out only rows modified within certain time period from a
database. As I undertand a way out could be adding an where clause for
the time period might be an option, I might be wrong here again.

But, wanted to know is there any other option. Can triggers or any
other things help me in this matter.

Regards,
Abhijeet

<abhi.10dulkar (AT) gmail (DOT) com> wrote

end_date_range.

This is assuming you have a field called changed_date and that it is the
date it changed. If you don't then you can't you would have to add the
field and have a method of updating it when a record is added or updated.
Jim

abhi.10dulkar (AT) gmail (DOT) com wrote:
welcome!

sure, my first thought is to insure that you have a TIMESTAMP or
DATETIME column. Which database are you using? And can you modify the
table to add such a field?

Just brainstorming, the commit log (which keep track of all changes to
the database) might be another way to do it. But I think the
timestamp/datetime option is cleaner.

The WHERE clause option sounds good. What is the overall application
scenario? Why would you want anything other than a WHERE clause?