Hello.
Search in the archives at: http://lists.mysql.com/mysql BETWEEN is meant among other operators at: http://dev.mysql.com/doc/mysql/en/using-date.html But be aware of that when you're using a datetime columns the query: SELECT a from b WHERE a BETWEEN '2005-01-01' and '2005-01-03'; is equal to the following one: SELECT a from b WHERE a BETWEEN '2005-01-01 00:00:00' and '2005-01-03 00:00:00'; And record with a='2005-01-01 19:00:00' won't be included in the result set. Erfan Shirazi wrote: > It works fine, no errors and it seems to get correct data but the mysql > manual and some other books doesn't mention anything about BETWEEN being > used like this and therefor I'm not completely sure, anybody with any > experience with my example? > > Erfan Shirazi > Application Developer, Information Technology - Shipco Transport > Email: [EMAIL PROTECTED] > Phone: +45 39 15 05 63 > > > > Felix Geerinckx wrote: > >> On 07/10/2005, Erfan Shirazi wrote: >> >> >> >>> I have a question about BETWEEN. >>> Could it be used to look up fields which have a date between to date >>> fields? >>> >>> Ex: '2005-10-07' BETWEEN tEffectivedate AND tExpirationdate >>> >>> tEffectivedate and tExpirationdate are DATE types. >>> >> >> >> What happened when you tried? >> >> >> > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
