Comparing Dates in Oracle SQL

I'm attempting to get it to show the number of workers employed after June 20, 1994.

Select employee_id, count(*)
From Employee
Where to_char(employee_date_hired, 'DD-MON-YY') > 31-DEC-95;

But I am getting an error:

"JUN' invalid identifier.

Can someone please help me with this?

Aug 9, 2022 in Database by Kithuzzz
• 38,010 points • 1,875 views

No answer to this question. Be the first to respond.

Your name to display (optional):

Email me at this address if my answer is selected or commented on:

Privacy: Your email address will only be used for sending these notifications.