How do I select one certain date to be returned?  I have a table that has a

date-time field in it and I want to return all records for a certain date.

However, since it also has the time in it, I'm not getting the records I

want.  This doesn't work:



SELECT * FROM tblTable WHERE dtStartDate = '06/25/2001'



TIA,

Owen

SELECT *

FROM tblTable

WHERE CONVERT(varChar, dteStartDate, 103) = '06/25/2001'



is one method



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

----- Original Message -----

From: "Owen Mortensen" <ojm@a...>

To: "ASP Databases" <asp_databases@p...>

Sent: Friday, June 29, 2001 8:29 AM

Subject: [asp_databases] SQL Date question....





: How do I select one certain date to be returned?  I have a table that has

a

: date-time field in it and I want to return all records for a certain date.

: However, since it also has the time in it, I'm not getting the records I

: want.  This doesn't work:

:

: SELECT * FROM tblTable WHERE dtStartDate = '06/25/2001'

:

: TIA,

: Owen