| Author |
 Topic  |
|
|
rnelsch
Starting Member
USA
31 Posts |
 Posted - 04/25/2012 : 15:50:18
|
Its been years since I've written a query to include a date but ignore the time. Out field has both date and time built in, ie. 4/25/2012 9:11:42 AM and I want to run a query using the "Where" clause for the date but not the time? Any suggestions?
Ryan A Nelsch |
|
|
Lamprey
Flowing Fount of Yak Knowledge
3831 Posts |
Posted - 04/25/2012 : 17:02:14
|
Assuming you want all rows with a date equal to 2012-04-25, then something like:SELECT *
FROM TableName
WHERE DateTimeColumn >= '20120425'
AND DateTimeColumn < '20120426' |
 |
|
|
sql-programmers
Posting Yak Master
USA
189 Posts |
Posted - 04/25/2012 : 23:13:55
|
Hi,
DECLARE @STARTDATE DATETIME = '4/25/2012 9:11:42 AM'
DECLARE @ENDDATE DATETIME = '4/26/2012 9:11:42 AM'
SELECT @STARTDATE, @ENDDATE
SELECT CONVERT(VARCHAR, @STARTDATE, 112), CONVERT(VARCHAR, @ENDDATE, 112)
FROM TableName
WHERE CONVERT(VARCHAR, DateTimeColumn, 112) >= CONVERT(VARCHAR, @STARTDATE, 112)
AND CONVERT(VARCHAR, DateTimeColumn, 112) < CONVERT(VARCHAR, @ENDDATE, 112)
SQL Server Programmers and Consultants
http://www.sql-programmers.com/ |
|
|
|
khtan
In (Som, Ni, Yak)
Singapore
16746 Posts |
Posted - 04/25/2012 : 23:24:44
|
quote:
Originally posted by sql-programmers
WHERE CONVERT(VARCHAR, DateTimeColumn, 112) >= CONVERT(VARCHAR, @STARTDATE, 112)
AND CONVERT(VARCHAR, DateTimeColumn, 112) < CONVERT(VARCHAR, @ENDDATE, 112)
SQL Server Programmers and Consultants
http://www.sql-programmers.com/
Applying function on the column will result in the engine not able to utilize any index on the DateTimeColumn.
The method posted by Lamprey is recommended.
KH
Time is always against us
|
|
|
|
madhivanan
Premature Yak Congratulator
India
22461 Posts |
|
| |
Topic |
|
|
|
Date Time Fields
