Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Date range query

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-07-23 : 09:34:16
Jason writes "I suppose I am rust but..

I am trying to create a query to get all the data for a particular date. No problem. But I have different time stamps so if I query

Select fldDate
from tblData
where fldDate = '07/14/01'

I only get the following:

flddate
---------------------------
2001-07-14 00:00:00

(1 row(s) affected)


How can I create this query to give me the right data set?

Help!! I know this is sophmoric but I really can't find any good resources on this dilemma.

jason@cabhansen.com"
   

- Advertisement -