MySQL Where Date is greater than today

Question

I try to get every record from my MySQL database which is greater than today.

SELECT `contract_to`
     , CURDATE() 
  FROM `contacts` 
 WHERE `contract_to` > 'CURDATE()'

Actual Result I expected
contract_to  |  CURDATE()
2021-03-27   |  2019-03-30

but I got the following

contract_to  |  CURDATE()
2019-03-20   |  2019-03-30
2021-03-27   |  2019-03-30

SELECT contract_to, CURDATE() FROM contacts WHERE contract_to < CURDATE() — Joaozinho das Couves, Mar 30 '19 at 07:47
Are the single quotes around curdate() at the end of the query intentional. Try removing them... So your condition is contract_to > CURDATE() — LJ01, Mar 30 '19 at 07:52
If you're still struggling, see https://meta.stackoverflow.com/questions/333952/why-should-i-provide-an-mcve-for-what-seems-to-me-to-be-a-very-simple-sql-query — Strawberry, Mar 30 '19 at 09:53

score 0 · Answer 1 · answered Mar 30 '19 at 08:05

0

SELECT contract_to FROM contacts WHERE contract_to > CURDATE();

answered Mar 30 '19 at 08:05

KRISHNA KANT SINGH

77
1
5

score 0 · Answer 2 · answered Mar 30 '19 at 08:06

0

Try this one

SELECT contract_to, CURDATE() FROM contacts WHERE PERIOD_SUB(contract_to,CURDATE())>0

it should do the trick

answered Mar 30 '19 at 08:06

Hondo Onhaka

13
5

MySQL Where Date is greater than today

2 Answers2