Looks like you'll need to manipulate the year part of the string:

DECLARE @cDateVar VARCHAR(24)
SELECT @cDateVar = '11262004 09:34:18'

SELECT CONVERT(DATETIME,
SUBSTRING(@cDateVar, 5, 4) +
SUBSTRING(@cDateVar, 1, 4) + ' ' +
SUBSTRING(@cDateVar, CHARINDEX(' ', @cDateVar) + 1, DATALENGTH(@cDateVar) - CHARINDEX(' ', @cDateVar))--)
)


-----Original Message-----
From: Femi George [ MTN - UBA ]
[mailto:mssqldba-ezmlmshield-x1174216.[Email address protected]
Sent: Monday, November 29, 2004 6:19 AM
To: LazyDBA Discussion
Subject: SUSPECT: CONVERTING ORACLE DATE TO SQL SERVER DATE FORMAT


Hello,
I have received a date from oracle in the format 26112004 09:34:18 and i
have inserted it into a varchar field in sql server. I now want to format
this into a sql server date format . How can i do this?
Thanks
Femi George
Enterprise Data Warehousing [MTN-AGIP]
[Email address protected]
08032090305



NOTE: This e-mail message is subject to the MTN Nigeria disclaimer see
http://www.mtnonline.com/contact/disclaimer.asp


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]



MS Sql Server LazyDBA home page