SQL to notify a certain date 2 days before the same in SQLite

1

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

Can anyone help me the Bank is SQLite !!

    
asked by anonymous 22.06.2017 / 17:16

1 answer

0

What about:

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

Explanation:

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

    
22.06.2017 / 22:07