x = pd.DataFrame({'ts': pd.date_range('2017-01-01', freq='999999S', periods=5)}
    )
Trying to convert column headings which are in datetime.datetime format 2016-09-01 00:00:00 to datetime.datetime format to '2016-09-01'