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?


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to