How to use greater than operator with date

Question

No idea what is going on here   Here is the query  right from phpMyAdmin   SELECT   FROM  la schedule  WHERE  start date   gt  2012-11-18     But I consistently get all records in the table returned  including those with start date 2012-11-01   What gives

User · Accepted Answer

you have enlosed start date with single quote causing it to become string  use backtick instead  SELECT   FROM  la schedule  WHERE  start date   gt   2012-11-18      SQLFiddle Demo

User · Answer

Try this   SELECT   FROM la schedule WHERE  start date   gt   2012-11-18

User · Answer

In my case my column was a datetime it kept giving me all records  What I did is to include time  see below example  SELECT   FROM my table where start date  gt   2011-01-01 01 01 01

User · Answer

Adding this since this was not mentioned  SELECT   FROM  la schedule  WHERE date start date   gt  date  2012-11-18    Because that s what actually works for me  Adding date   function on both comparison values

User · Answer

In your statement  you are comparing a string called start date with the time   If start date is a column  it should either be       SELECT   FROM  la schedule  WHERE start date   2012-11-18        no apostrophe  or    SELECT   FROM  la schedule  WHERE  start date    2012-11-18       with backticks      Hope this helps

User · Answer

I have tried but above not working after research found below the solution   SELECT   FROM my table where DATE start date   gt   2011-01-01     Ref

[mysql] How to use greater than operator with date?

Examples related to mysql

Examples related to date

Examples related to operators