simple date query I can't do

[warby1212]

Hi,

I'm new to Mysql so this is probably pretty obvious but can't find a simple answer in docs.

I have data in column formatted as DATE and want to select rows where date (column is called "birth") is 40 days from the current date.

Any help appreciated

http://www.deepconnection.com

Way away in Australia

 

[TonyGroves]

How about:[tt]

SELECT *
FROM tbl
WHERE birth = CURDATE() - INTERVAL 40 DAY[/tt]

Or, if you mean 40 days after the current date, change the minus to a plus.


-----
ALTER world DROP injustice, ADD peace;

 

[sleipnir214]

You might try MySQL's date_sub() function:

SELECT *
FROM tablename
WHERE
datecolumn > date_sub (now(), INTERVAL 41 DAY)


Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[warby1212]

Thank you guys. I haven't replied because I'm trying to make it work between a thousand other things. thanks again will let you know.

http://www.deepconnection.com

Way away in Australia

 

[KarveR]

so you want 40 days notice on someones brithday ?



______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[warby1212]

That's right. It's just for my home page on my own PC. I still can't get it to work. The helpful people above answered my wrong question, correctly. (I've realized) 40 days before the person's birth is actually no help, what I need is 40 days before their birthday this year. So it needs to be relative to the month part of the the DATE data. Any help?

http://www.deepconnection.com

Way away in Australia

 

[warby1212]

Found it. I must learn to pester Google before people.
Thanks all

SELECT name, birth FROM birthdays WHERE MONTH(birth) = MONTH(DATE_ADD(CURDATE(),INTERVAL 1 MONTH))

http://www.deepconnection.com

Way away in Australia

 

[KarveR]

Thats the way !

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.