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 vote133 views1 answer
What is delimiter in mysql
SQL
0 vote110 views1 answer
Pl sql turn off variable substitution
SQL
0 vote122 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL
0 vote127 views1 answer
Mysql join only one column
SQL
0 vote113 views1 answer
Update top 100 sql
SQL
1 vote111 views1 answer
Postgresql filter on
SQL
0 vote102 views1 answer
Sql create text column limited values
SQL
0 vote119 views3 answers
Sql drop all tables
SQL
0 vote133 views1 answer
Postgresql port 5432 not open
SQL
0 vote112 views1 answer
How to order result of subquery in select
SQL