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 vote151 views1 answer
Doctors appointment
SQL
11 votes121 views1 answer
How to get ddl for materialized view
SQL
0 vote136 views1 answer
Mysql into outfile with headers
SQL
0 vote112 views1 answer
Resulting Query
SQL
0 vote126 views1 answer
Oracle execute immediate quotes
SQL
0 vote128 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL
1 vote113 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
0 vote112 views1 answer
2020 new year
SQL
1 vote116 views1 answer
ELECT list is not in GROUP BY clause and contains nonaggregated column 'schogdsw_db.SE.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
10 votes134 views2 answers
Reset mysql root password mac
SQL