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
On 07/10/2005, 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?
I regularl
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 Te
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 t
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
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
