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.)

like for example

SELECT * FROM ORDERS
WHERE ROW CHANGE TIMESTAMP FOR ORDERS >
CURRENT TIMSTAMP - 24 HOURS;
returns all the rows that have been changed in the last day


Thank you
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to