selecting data from mysql table based on a date column and condition

Question

I have a column in mysql table PACKAGES as SERVICE_EXPIRY_DATE which holds a date time value.

Now I want to match only those records whose SERVICE_EXPIRY_DATE is coming within the next 15 days from the moment of querying.

How can I match those columns.

[BY reading that how to ask a good question on SO](https://stackoverflow.com/help/how-to-ask) — Alive to die - Anant, Apr 24 '18 at 06:24
Worth a [read](https://stackoverflow.com/questions/24272335/mysql-select-last-7-days) — hungrykoala, Apr 24 '18 at 06:25

score 2 · Accepted Answer · edited Apr 24 '18 at 06:53

2

You could do it by using intervals

WHERE `SERVICE_EXPIRY_DATE` BETWEEN NOW() AND DATE_ADD(NOW(), INTERVAL 15 DAY)

edited Apr 24 '18 at 06:53

ScaisEdge

answered Apr 24 '18 at 06:29

finnishNinja

1 Answers1