Help with simple query

Saeven

Hello.

Here's my dilemma😕.

I have a mySQL database table which has two entries of interest. The first is a timestamp(8) and the second is a month entry.

These timestamps are dates that represent when the item was created, and the months indicate how long it will last.

I would like to, with mySQL only, be able to query all rows in this table that will expire in a selected amount of time from now, 2 days, 3 weeks, 1 month, etc.

Can this be done?

Thanks in anticipation.
Alex

nemonoman

Yes.

Supposedly offering strategies is better than writing code, so think about it:

You want to add
Timestamp and Months to Expire, yes?

Then compare to a date certain, right? Like adding
2 weeks to Current Date, yes?

So it's

WHERE...

Hint: look up the DATE_ADD() function in MYSQL manual.

Saeven

Hi, I can syntactically understand that manual, what I don't understand is how to collate the mySQL queries to both retrieve the fields and process them in one line.

If any knowledgeable person can give me a solution, ie an example query line; it would help me greatly.

No riddles please.

Again, anxious for an answer.
Alex

nemonoman

SELECT *
FROM table
WHERE
DATE_ADD( col_timestamp,
INTERVAL col_months_to_run MONTH ) <
DATE_ADD(CURRENT_DATE, INTERVAL 2 DAY)

You'll need to fill in the approriate values

for table
col_timestamp
col_months_to_run

using the names from your database.

Saeven

Thanks!
Exactly what I needed.