I have a column name `'Cos_Date'` with value like 14APR2017:00:00:00.

However, for a new column name `'Arrival_Date'`, I would like to keep the date information but omit time, and keep the data type as `Date` but not `Character`. Ex, 14APR2017.

I have tried:

```
  select TO_CHAR(Cos_Date, 'DD-MON-YYYY') ARRIVAL_DATE

```

But it will delete time information, but data type turns to `Character`.

I search on this site, and tried both:

```
  select TO_DATE(TO_CHAR(Cos_Date, 'DD-MON-YYYY'), 'DD-MON-YYYY')  ARRIVAL_DATE

```

and:

```
  select TRUNC(Cos_Date) ARRIVAL_DATE

```

But it will not omit time information. 

Can I try something else? 

Thank you!