SQL to notify a confirmed date 2 days before the same in Sqlite

Question

Dear Programmers I am beginner and would like to know how do I make an sql notify me of a certain date in the database, for example: 28/06/2017 I want when I arrive two days before give me a return on this case day 26/06/2017.

Can someone help me the Bank is the Sqlite!!

Answer 1

How about:

sqlite> SELECT date( 'now', '+2 day') >= date('2017-06-24');
1

Explanation:

If today’s date is 2017-06-22 is the +2 dias date of registration tested (in case: 2017-06-24), the expression will return verdadeiro.