>>>>then that would be a problem. Period.
>>>>
>>>>Cetin
>>>
>>>But this is not the result I want.
>>>
>>>Ok, I ask you now to write me a query to return all records for today's date. Please write it using BETWEEN operator. My dates are stored with time portion.
>>>
>>>Thanks in advance,
>>
>>
>>dStart = date()
>>dEnd = date()+1
>>
>>select * from myTable where myDateTime between ?m.dStart and ?m.dEnd and myDate < ?m.dEnd
>>
>>Cetin
>
>I knew it in advance. You're still using 2 operators, not between only, so it's the same as
>
>myDateTime >= ?m.dStart and myDate < ?m.dEnd
>
>End of discussion.
Yes since you created the discussion in the first place with your own restrictions you have the right to confirm and end it:)
Cetin