Compare date in sql

WHERE DATEDIFF(my_date,'2008-11-20') >=0;
WHERE my_date >= '2008-11-20';
WHERE to_date(my_date, 'YYYY-MM-DD') >= '2008-11-20';
WHERE to_date(my_date, 'YYYY-MM-DD') >= to_date('2008-11-20', 'YYYY-MM-DD');

Similar codes

0 vote337 views1 answer
Install mysql on bash
SQL
0 vote285 views1 answer
Value of sold product using having and group by in sql
SQL
0 vote317 views1 answer
Create synonym for dblink in oracle
SQL
0 vote330 views1 answer
Find and replace query in wordpress\
SQL
0 vote359 views1 answer
Trigger
SQL
2 votes302 views1 answer
Search query in mysql
SQL
0 vote263 views1 answer
What are the aggregate function in sql
SQL
11 votes283 views2 answers
Having in sql
SQL
-1 vote241 views1 answer
How to create script to connect to oracle database and run query
SQL
-2 votes290 views1 answer
Group functions in sql
SQL