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 vote183 views1 answer
Get cpu details sql
SQL
0 vote166 views1 answer
How to convert DateTime to VarChar SQL
SQL
2 votes193 views1 answer
Mysql select true or false
SQL
0 vote165 views2 answers
Mysql disable foreign key checks
SQL
0 vote197 views1 answer
Varchar format not case sensitive sql
SQL
1 vote179 views1 answer
Oracle check table space
SQL
0 vote171 views1 answer
Postgres create extension if not exists
SQL
0 vote167 views1 answer
How to count with except in psql
SQL
0 vote161 views1 answer
Oracle for loop on list
SQL
0 vote179 views1 answer
Oracle calculate statistics on partition
SQL