Hi all

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.

Best Regards,

--
Erfan Shirazi
Application Developer, Information Technology - Shipco Transport
Email: [EMAIL PROTECTED]
Phone: +45 39 15 05 63



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

Reply via email to