Plane number to Date conversion in OBIEE

Converting the number to date is our current requirement. I have read some blogs and found this formula and tried.It is working fine.

CAST ( LEFT( CAST ('our date column' AS CHARACTER ( 10 )), 4) || '/' || SUBSTRING( CAST ('our date column' AS CHARACTER ( 10 )) FROM 5 FOR 2) || '/' || SUBSTRING( CAST ('our date column' AS CHARACTER ( 10 )) FROM 7 FOR 2) AS DATE )
The format of the number is 20120202 which i want as 2012/02/02