select date_add mysql issue

Question

i have a table loans in a database with the schema that like this

loans
-----
period (vchar) ' but it contains number string
date
amt
user

i needed to select all the records from a loans where the the date + period is equal to or greater than current date. when i execute the query below

SELECT * 
FROM loans
WHERE DATE( DATE_ADD( DATE, INTERVAL period
DAY ) ) >= CURRENT_DATE
LIMIT 0 , 30

i get all the records in the loans table. what is the problem?

Is pay_period intended as period? Are they different columns or is one a typo here? — Michael Berkowski
– Michael Berkowski, Commented May 21, 2013 at 1:02
@FreshPrinceOfSO: i update my post. the period is a varchar field, but its numeric — Oghenero E.
– Oghenero E., Commented May 21, 2013 at 1:06

Kermit · Accepted Answer · 2013-05-21 01:23:12Z

1

Is this what you're looking for?

SELECT columnList
FROM loans
WHERE CURDATE() < DATE_ADD(`date`, INTERVAL pay_period DAY)

answered May 21, 2013 at 1:23

Kermit

34.1k13 gold badges89 silver badges121 bronze badges

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

Collectives™ on Stack Overflow

select date_add mysql issue

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