[Resolved] datetime issue

[bengt]

Hello there

I'm creating an auction site, and I need a way to show just the open auctions. I have a field 'start' wich is DATETIME, end 'end' wich also is DATETIME.
How can I select only the rows where now() is between 'start' and 'end'?

This solved it

WHERE start <= now() AND end >= now()

[hthighway]

SELECT something FROM table WHERE TO_DAYS(NOW()) BETWEEN TO_DAYS(start) AND TO_DAYS(end)

-Paul