oracle date to sql server format

[eja2000]

i have 26022005 09:34:18 in avarchar field.
how can i format this to a date?
thanks..
it came from an oracle database.

 

[JamesLean]

Use this script to add in some slashes:

update tbl
set col = stuff(col, 3, 0, '/')

update tbl
set col = stuff(col, 6, 0, '/')

Then use this to change the column to datetime:

SET DATEFORMAT dmy

ALTER TABLE tbl
ALTER COLUMN col datetime

--James