Archives of the TeradataForum
Message Posted: Wed, 17 Aug 2005 @ 18:09:14 GMT
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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|