Skip navigation links

MySQL Forums :: PHP :: Query with overall date range and start/end time ranges


Advanced Search

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: Reply•Quote


Subject Written By Posted
Query with overall date range and start/end time ranges Rational Rabbit 04/23/2012 07:53AM
Re: Query with overall date range and start/end time ranges laptop alias 04/23/2012 08:02AM
Re: Query with overall date range and start/end time ranges Rational Rabbit 04/23/2012 11:23AM
Re: Query with overall date range and start/end time ranges laptop alias 04/23/2012 12:57PM
Re: Query with overall date range and start/end time ranges Rational Rabbit 04/23/2012 07:36PM
Re: Query with overall date range and start/end time ranges Rick James 04/25/2012 09:22PM
Re: Query with overall date range and start/end time ranges Rational Rabbit 04/26/2012 08:10PM
Re: Query with overall date range and start/end time ranges Rick James 05/02/2012 11:24PM
Re: Query with overall date range and start/end time ranges banica derp 05/01/2012 08:02AM


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

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.