convert MM/DD/YYYY to YYYYMMDD in redshift

I have a requirement to convert MM/DD/YYYY to YYYYMMDD in amazon redshift database.

My result of this query gives me some weird result. Can some one please help me.

select to_date ('07/17/2017','YYYYMMDD');

0007-07-20