MySQL Forums
Forum List  »  PHP

Re: Query with overall date range and start/end time ranges
Posted by: Rick James
Date: April 25, 2012 09:22PM

You would probably be better off with DATETIME, not DATE + TIME.

This might work: WHERE (date, time) >= ('2010-10-24', '09:05:20') ...
It is a little-used (and poorly optimized) what of comparing pairs of things that belong together.

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.