Archives of the TeradataForum

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

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

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>>