title: convert MM/DD/YYYY to YYYYMMDD in redshift
body: <p>I have a requirement to convert MM/DD/YYYY to YYYYMMDD in amazon redshift database.</p>
  
  <p>My result of this query gives me some weird result. Can some one please help me.</p>
  
  <p>select to_date ('07/17/2017','YYYYMMDD');</p>
  
  <p>0007-07-20</p>