[SOLVED] where clause date out of date time field

[anatak]

Hello I am trying to have a query that selects events that are happening today.

I have a event start field and an event end field.

both are datetime fields

the problem I have is that when I select the events with this where clause

WHERE t01_01.StartDate <= '$today'

AND t01_01.EndDate >= '$today'

AND t05_01.Id = 2;"

$today (is todays date only in a date format yyyy-MM-DD)

 

How can I date format the StartDate and EndDate ?

something like this

DATE_FORMAT(t01_01.StartDate,'%M %D, %Y')

in the where clause ?

 

kind regards

anatak

 

[mjahkoh]

this works. Just tested it

select * from seasons_dt

WHERE date_format(datefrom,'%e-%b-%Y')  < now() or  date_format(datefrom,'%e-%b-%Y')  > now()

[anatak]

thanks

It works as it should now.

topic closed