SYSCREATEDATE is saved as varchar2 in DB. Value is as follows:

```
SYSCREATEDATE
10/17/2006 7:44
11/29/2011 6:17
11/16/2011 11:46
2/27/2012 4:01
2/27/2012 4:01
2/27/2012 4:01

```

Now i want to convert the field to timestamp and pick dates less than a certain date say '06/01/2020'.

Tried this:

```
select * from legacy_case where  TO_TIMESTAMP(SYSCREATEDATE, 'MM/DD/YYYY HH:MI:SS') < '06/01/2020 00:00:00';

```

I am getting the below error:

```
ORA-01843: not a valid month
01843. 00000 -  "not a valid month"
*Cause:    
*Action:

```

Any input please?