How to you compare dates in a query in Mysql

[Safal Solutions]

Dear friends,

Plesae help in finding the correct syntax for comparing two dates in a query
in MySql database

Thank you
Subodh Gupta

[Sven]

take a look into mysql-manual > 6.3.1.2 Comparison Operators
ciao SVEN

Bogdan Stancescu wrote:

> Depends on what exactly you're after, but for strict comparison
> arithmetic operators work as expected (<, >, =).
>
> Bogdan
>
> Safal Solutions wrote:
>

>> Dear friends,
>>
>> Plesae help in finding the correct syntax for comparing two dates in
>> a query in MySql database
>>
>> Thank you
>> Subodh Gupta

[Unregistered]

Imagine ur table name as Test 1 which contains two columns "createdate" & "updatedate" & Now if you want to get the records which are created between '01/01/2010' and '31/01/2010' and updated between '01/02/2010' and '28/02/2010' Then Your Query Goes in the below way :

select * from Test1
WHERE Createdate between '2010-01-01' and '2010-01-31'
AND Updatedate between '2010-02-01' and '2010-02-28'

The above query retrieves the data in between the given dates and does not include the action on the given dates....


Regards,
Naresh Vodnala