I have a column which holds date values as varchar as in the format of

```
date_n                    date_s
2016-11-10::12:36:05      2016-NOV-10::12:36:05
2016-11-10                2016-NOV-10

```

Now all I need is to get date from both of columns but I am only able to get from column `date_n` along with timestamp and nothing from `date_s` The query I tried as

```
SELECT * FROM table where CAST(date_n AS DATE)=CURDATE();

```

which returns both element as result but when I change `date_n` to `date_s` returns empty and all I need output as `date` only no time stamp

So is there any way to sort this out