CODEWITHSUNDEEP
mysql
Ashok
Ashok

Reputation: 51

how to get birthday date in mysql query (condition is if your birthday is today means to know it before two days itself)?

SELECT username, dob FROM userdetails 
WHERE  
(MONTH(dob), DAY(dob)) = (MONTH(CURDATE()),DAY(CURDATE()))

above query I tried to get CURDATE birthday person's username & DOB it's working But, actually My need is If the person have b'day today i wan't to know it two days before itself. I stuck up here so, kindly help me please ????

Upvotes: 4

Views: 5964

Answers (3)

Adarsh
Adarsh

Reputation: 726

SELECT username, dob FROM userdetails WHERE DAY(dob) = DAY(ADDDATE(CURDATE(), INTERVAL 2 DAY)) AND MONTH(dob) = MONTH(ADDDATE(CURDATE(), INTERVAL 2 DAY))

Upvotes: 1

Ashok
Ashok

Reputation: 51

SELECT * FROM user_login_details WHERE DAY(dob) = DAY(NOW() + INTERVAL 2 DAY) AND MONTH(dob) = MONTH(NOW());

Upvotes: 1

Arun Krish
Arun Krish

Reputation: 2153

Try like this

SELECT username, dob FROM userdetails WHERE
STR_TO_DATE( CONCAT(YEAR(CURDATE()), '-', MONTH(dob), '-', DAY(dob) ), '%Y-%m-%d' ) = DATE_ADD(CURDATE(), INTERVAL 2 DAY)

Upvotes: 3

Related Questions