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

Question

I m trying    SELECT    FROM dbo March2010 A WHERE A Date  gt   2010-04-01    A Date looks like  2010-03-04 00 00 00 000  However  this is not working    Can anyone provide a reference for why

User · Answer

DateTime start1   DateTime Parse txtDate Text    SELECT    FROM dbo March2010 A WHERE A Date  gt   start1    First convert TexBox into the Datetime then    use that variable into the Query

User · Answer

select     from dbo March2010 A  where A Date  gt   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  gt   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  gt    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

User · Answer

We can use like below as well  SELECT    FROM dbo March2010 A WHERE CAST A Date AS Date   gt    2017-03-22    SELECT        FROM dbo March2010 A     WHERE CAST A Date AS Datetime   gt    2017-03-22 06 49 53 840

User · Answer

To sum it all up  the correct answer is    select   from db where Date  gt    20100401    Format of date yyyymmdd    This will avoid any problem with other language systems and will use the index

User · Answer

Try enclosing your date into a character string    select     from dbo March2010 A  where A Date  gt    2010-04-01

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

Examples related to sql

Examples related to sql-server

Examples related to datetime