SQL Query using INTERVAL

Question

i am using this SQL Statement in PHP:

$sql2="SELECT * from billing_pdf_archive2 where datetime = DATE(NOW() - INTERVAL 14 DAY) and sequence = '".$result["sequence"]."' ";

its working fine however it is only selecting 14 days ago exactly from the datetime field. is there any way i can make it select 14 days ago and older? so 15, 16, 17, 18 days and so on.... but never less that 14 days

Kenny · Accepted Answer · 2013-06-21 08:08:17Z

1

More than 14 days ago:

$sql2="SELECT * from billing_pdf_archive2 where datetime < DATE(NOW() - INTERVAL 14 DAY) and sequence = '".$result["sequence"]."' ";

answered Jun 21, 2013 at 8:08

Kenny

5,4007 gold badges32 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL Query using INTERVAL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related