oracle date to sql server format

eja2000 · Nov 29, 2004

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 · Nov 29, 2004

Use this script to add in some slashes:

Code:

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:

Code:

SET DATEFORMAT dmy

ALTER TABLE tbl
ALTER COLUMN col datetime

--James