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]