date functions in mysql

[mickit]

hello

i made a small mistake but i don't want to rewrite my script
so perhaps there is an other way

i have 3 int values standing for year moth day
i didn't use the unixtimestamp - and yes i kn ow this would be easier

so my question.

is there a way, to get all the entries, which are in the future

like this:
where DATE(year,monthm,day) >= 'act_time'

??

 

[KarveR]

where DATE(year,month,day)>= curdate()

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

 

[TonyGroves]

I think you would have to do it like this:
[tt]
WHERE
CONCAT(
year,'-',LPAD(month,2,'0'),'-',LPAD(day,2,'0')
)
>=CURDATE()
[/tt]
assuming the year is in 4-digit form.

This is likely to be quite slow though, so you might be better off restructuring your table to use a DATE field if possible.


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

 

[mickit]

hm none of them are working - no errormsg - just no results
damn

any other ideas

 

[mickit]

oh sorry my fault - it works
thx