How do I query for all dates greater than a certain date in SQL Server?

How do I query for all dates greater than a certain date in SQL Server?

select *  
from dbo.March2010 A 
where A.Date >= Convert(datetime, 2010-04-01 )

In your query, 2010-4-01 is treated as a mathematical expression, so in essence it read

select *  
from dbo.March2010 A 
where A.Date >= 2005; 

(2010 minus 4 minus 1 is 2005
Converting it to a proper datetime, and using single quotes will fix this issue.)

Technically, the parser might allow you to get away with

select *  
from dbo.March2010 A 
where A.Date >= 2010-04-01

it will do the conversion for you, but in my opinion it is less readable than explicitly converting to a DateTime for the maintenance programmer that will come after you.

Try enclosing your date into a character string.

 select * 
 from dbo.March2010 A
 where A.Date >= 2010-04-01;

How do I query for all dates greater than a certain date in SQL Server?

We can use like below as well

SELECT * 
FROM dbo.March2010 A
WHERE CAST(A.Date AS Date) >= 2017-03-22;

SELECT * 
    FROM dbo.March2010 A
    WHERE CAST(A.Date AS Datetime) >= 2017-03-22 06:49:53.840;

Leave a Reply

Your email address will not be published.