Archives of the TeradataForum

Message Posted: Wed, 17 Aug 2005 @ 18:09:14 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

I am trying to convert an Oracle date to a TD date. The Oracle Date is in a 'ddmmmyyyy:hh:mm:ss' format. I import it as a Char field into a temp table, and now I want to import it into a TD table as just a date.

I have tried

     Select cast (Substring(oracledate from 1 for 9) as date (format 'ddmmmyyyy'))
        from temptable.

But I get a bunch of syntax or invalid date errors.

I even tried

     Select cast('01jan2000' as Date);

with different syntax, but can't find the right combination.

I don't have access to the Oracle Db, so I can't use OLE Mod. Can someone who has work with the ddmmmyyyy:hh:mm:ss format in an ASCII file layout give me some direction?

Thanks

Bill H

	<Prev	Next>		<<First	<Prev	Next>	Last>>