MySQL Forums
Forum List  »  Other Migration

Select records by MAX(time) - 90 days
Posted by: Gary Ehrenfeld
Date: December 21, 2018 06:25AM

I have a sqlite3 database that has data downloaded from my diabetes meter. I download the data from the meter daily.

I now do a calculation on the database using every record in the database.

What I need to do is get a list from the database that comprises all the records that are from the last date that was appended minus 90 days to the last append record.

example: Select * from meter where time > last append time -90 days

Hope I made sense of what I need to do.



Options: ReplyQuote

Written By
Select records by MAX(time) - 90 days
December 21, 2018 06:25AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.