Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 15 Dec 2006 @ 13:07:20 GMT


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


Subj:   Error in Converting date from Oracle table to
 
From:   RAJESH.TAMBE

Hi,

I want to load some data from an Oracle table to Teradata table, however some date fields are giving error while converting to character since it is loaded in Teradata date format.

Herebelow the query on oracle server :

     select policy_no,doj_scheme,
     to_date(doj_scheme,'dd-mm-yyyy'),to_char(doj_scheme) from ggca_employees
     where to_char(doj_scheme,'yyyy-mm-dd')='0000-00-00'

the results are like :

     pol_no   doj_sche    to_date     to_char
     ------   ---------   ---------   ---------
     405729   01-MAR-01   01-MAR-01   00-000-00
     405729   01-MAR-01   01-MAR-01   00-000-00
     405729   01-MAR-01   01-MAR-01   00-000-00
     405729   01-MAR-01   01-MAR-01   00-000-00
     405729   01-MAR-01   01-MAR-01   00-000-00
     405729   01-MAR-01   01-MAR-01   00-000-00

Can anybody help in resolving the problem.

thanx


Regards,

Rajesh



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