CODEWITHSUNDEEP
mysqlsqldate
user236501
user236501

Reputation: 8648

SQL statement to get the date next 2 days from now

I want to get the data which the date is next 2 days from today below are my sql statement, i am using mysql

SELECT * 
FROM guest g inner join reservation r on g.nric = r.guestNric 
WHERE arrivalDate = DATE_ADD(NOW(), INTERVAL +2 DAY)

My problem now is if i am using = becuase my arrivalDate format is 'yyyy-MM-dd' then the Date_Add format is come with timestamp so it wont be equals any idea how can i solve this problem?

Upvotes: 2

Views: 9102

Answers (2)

Dennis Traub
Dennis Traub

Reputation: 51654

Try replacing NOW()with CURTIME(). The type return value of DATE_ADD() corresponds to the type of the first parameter.

Upvotes: 0

Hck
Hck

Reputation: 9167

Try this:

SELECT * 
FROM guest g inner join reservation r on g.nric = r.guestNric 
WHERE arrivalDate = DATE(DATE_ADD(NOW(), INTERVAL +2 DAY))

Upvotes: 3

Related Questions