I have a Data frame column that looks like this:

```
df['Column_Name']
1   25/09/2019
2   26/09/2019
3   28/09/2019
4   2019-01-08 00:00:00
5   2019-02-08 00:00:00

```

The date type is object, I try to change using:

```
pd.to_datetime(df['Column_Name'], format="%d/%m/%Y")

```

Error:

```
ValueError: time data datetime.datetime(2019, 2, 8, 0, 0) does not match format '%d/%m/%Y' (match).

```

I want to have these result:

```
1   25/09/2019
2   26/09/2019
3   28/09/2019
4   01/08/2019
5   02/08/2019

```

Thanks in advance.