I’m trying to extract all the instances in which the dates in my table are ‘03-JUL-16’ but I’m getting zero results. Here is what I’ve tried:

```
SELECT *
FROM table1
WHERE purchase_date = ‘03-JUL-16’ ;

SELECT *
FROM table1
WHERE purchase_date like ‘03-JUL-16’;

SELECT *
FROM table1
WHERE purchase_date in ( ‘03-JUL-16’ );

```

Why am I getting zero results? How can I correct the queries above? What is the answer? Sorry if this is a simple question, I’m new to SQL and trying to learn. Thanks for the help!!