Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

Subj:   Oracle Date
From:   Hassinger, Bill

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?


Bill H

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020