TO_TIMESTAMP or TO_DATE needs specific format
485900Jul 18 2007 — edited Jul 18 2007I am doing some data cleansing and therefore have a table that has a value column that has some text in it. Currently I am trying to cleanse the dates but the problem is they are not in a consistant format (ie. 10/12/2007 6:00AM, 10/12/2006). The problem I have is that I need to convert these values to a timestamp so that I can do date processing on them and the TO_TIMESTAMP function requires a format if it is not in the Oracle format.
Does anybody know a way around this?