>> > What is the Query to get the updates from the table (updated (added, >> edited, >> > deleted row information) rows from last 5 mins/1 hour/5 hours/24 hours.)
If you don't store change timestamp of the row by yourself then there's no way to know when the row was last changed. Pavel On Thu, May 13, 2010 at 6:15 AM, Meenakshi Yakri <[email protected]> wrote: > thanks for reply > before also i have seen through this link... but I din't get any answer to > my question in this link > > On Thu, May 13, 2010 at 3:38 PM, Simon Slavin <[email protected]> wrote: > >> >> On 13 May 2010, at 10:20am, Meenakshi Yakri wrote: >> >> > Hi wanted to check >> > What is the Query to get the updates from the table (updated (added, >> edited, >> > deleted row information) rows from last 5 mins/1 hour/5 hours/24 hours.) >> >> http://www.sqlite.org/lang_datefunc.html >> >> See the 'Modifiers' section. >> >> Simon. >> _______________________________________________ >> sqlite-users mailing list >> [email protected] >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
