Sorry, there is no Datepart(date) syntax.
bob
>You can use the function
DATEPART()
which uses only the date.
>
>SELECT * from MyTable WHERE DATEPART(date) BETWEEN '01/01/2007' AND '01/02/2007'
>
>
>Glenn
>
>>We have a number of queries we write that look only at the date portion of a datetime field. I was wondering if anyone has an efficient way of looking at just the date. For example
>>
>>SELECT * from MyTable WHERE date = '01/01/2007'
>>
>>With the above query the following would be selected
>>
>>DATE = 01-01-2007 00:00:00
>>
>>And the following would not:
>>
>>DATE = 01-01-2007 01:30:50
>>
>>or,
>>
>>SELECT * from MyTable WHERE date BETWEEN '01/01/2007' AND '01/02/2007'
>>
>>With the above query the following would be selected
>>
>>DATE = 01-02-2007 00:00:00
>>
>>And the following would not:
>>
>>DATE = 01-02-2007 01:30:50
>>
>>
>>Thanks.
>>
>>Bob Bartel