Results Unexpected

I have the following query: Select * from bar_events where date BETWEEN '02/26/2006' AND '03/04/2006'

For some reason it selects an event that is scheduled on 02/26/2007, why does it do that?

Thanks in advance.

Ask in the database section, they're good at this sort of thing.

Probably because the dates have been stored as strings instead of as dates.

Please don't post the same question in 2 forums, it is bad manners apart from anything else.

I would have moved it but I wasn't sure how to??

Even if I store it as string, can I change the column type so that it reconginzes it correctly?

If it's MySQL you could probably do something messy like this:

SELECT
*
FROM
bar_events
WHERE
CONVERT(bar_events.date AS DATE) BETWEEN CONVERT('02/26/2006' AS DATE) AND CONVERT('03/04/2006' AS DATE)

but it would probably be better if you could convert that column to a DATE/DATETIME