I have date column that contains date and time. I want to only get back
distinct dates in YYYYMMDD format.

I start with alter session set nls_date_format = 'YYYYMMDD'

When I run this query below
select distinct(create_date) from table_A partition (BLA)

I am getting back more than one row as shown below. What do I have to do to just one row per YYYYMMDD

CREATE_D
--------
20101021
20101021
20101021
20101021