[SOLVED] weird > and< date problem

[HughbertD]

For some reason if I do :

 

ev_dat < current_date its not the same as;

ev_dat < '2008-01-31'

 

Infact I have to do

 

ev_dat > '2008-01-31' to get the same result as

ev_dat < current_date;

 

Is there a known bug here?

[PFMaBiSmAd]

What data type is ev_dat and give a specific example of a value in ev_dat that you are testing with.

[Barand]

I'm going to guess that ev_dat is DATETIME and contains something like

 

2008-01-30 08:00:00

 

and if you use NOW() to get current_date and it is now 2008-01-30 12:00:00

 

So, ev_dat < NOW()

 

but '2008-01-30' is equivalent to 2008-01-30 00:00:00

 

therefore ev_dat > '2008-01-30'

 

 

If I'm right, and you are comparing datetime with date, use these

 

DATE(ev_dat) < CURDATE()

DATE(ev_dat) < '2008-01-30'

 

Then again I'm probably way out and should just wait for more info in response to PFMaBiSmAd's post.

 

[HughbertD]

Sorry for the lack of response.

 

Turns out I was passing the ev_dat from a form without ' ' marks.I put $_POST[ev_dat] in the single quotes and it works as normal

 

Thanks for the help everyone