Answers for "how to compare only the date in the data given in sql"

SQL
2

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');
Posted by: Guest on April-04-2021

Code answers related to "how to compare only the date in the data given in sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language