|
Posted by lorento on 06/09/06 04:09
wesley@ispace.co.za wrote:
> Hi All, i want to check if a date is in between two other dates. like
> prevDate < testDate < nextDate. What is the query for this? I know that
> date comparisons are not straight foward.
> Thanks Wes
Try this:
SELECT date FROM table WHERE date between prevDate and nextDate
--
http://blog.deshot.com
http://www.cookdojo.com
Navigation:
[Reply to this message]
|