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

5 votes379 views1 answer
Oracle get ddl
SQL
1 vote328 views1 answer
Does insert into overwrite sql
SQL
1 vote327 views2 answers
Mysql filter by date mount
SQL
2 votes336 views1 answer
Oracle kill job by sid
SQL
0 vote332 views1 answer
Get null value in sql
SQL
0 vote304 views1 answer
Procedures and functions in pl/sql
SQL
-2 votes344 views3 answers
How to fetch first 10 rows in sql
SQL
0 vote336 views1 answer
Mariadb cast null to 0
SQL
0 vote333 views1 answer
Sql get highest date from 3 tabels
SQL
0 vote359 views1 answer
Sql pivot without aggregate
SQL