SQL statement to get the date next 2 days from now

Question

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?

What database engine are you using? – maple_shaft May 23 '11 at 14:54 — maple_shaft, May 23 '11 at 14:54
He said mysql in the question text, just didn't tag it. – Jaymz May 23 '11 at 14:55 — Jaymz, May 23 '11 at 14:55

score 2 · Accepted Answer · answered May 23 '11 at 14:57

2

Try this:

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

answered May 23 '11 at 14:57

Hck

8,837
2
29
25

score 0 · Answer 2 · answered May 23 '11 at 14:58

0

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

answered May 23 '11 at 14:58

Dennis Traub

48,682
7
87
104

Hi, thanks for your replied i got incorrect datetime value error message – user236501 May 23 '11 at 15:01

SQL statement to get the date next 2 days from now

2 Answers2

Linked