garrydawkins
Programmer
SELECT count(*) FROM dbo.INCOMING_TEMP
where DATE_TIME > 2/1/2004 12:00:00 AM
and 3/1/2004 12:00:00 AM
where DATE_TIME > 2/1/2004 12:00:00 AM
and 3/1/2004 12:00:00 AM
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
What's Wrong with this
- Thread starter garrydawkins
- Start date
- Status
You may try something like this:
SELECT count(*) FROM dbo.INCOMING_TEMP
where DATE_TIME BETWEEN '2004-01-02 12:00:00' AND
'2004-01-03 12:00:00'
Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
SELECT count(*) FROM dbo.INCOMING_TEMP
where DATE_TIME BETWEEN '2004-01-02 12:00:00' AND
'2004-01-03 12:00:00'
Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
- Status
Similar threads
- Locked
- Question
- Locked
- Question