In this video, we will see how to use date fields or date columns in sql where condition.
SQL's used in this video are given below.
All employees hired in the month of August across years
select * from employees where to_char(hire_date,'MM') = '08';