Archives of the TeradataForum

Message Posted: Thu, 28 Oct 2004 @ 09:22:42 GMT

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

Hi Rommel,

Thanks for the suggestion. I have tried to achieve the same using the following

     INSERT INTO
     .......
      DTE_CRE  (DATE, FORMAT 'YYYY/MM/DD'),

     ORGN_PROV_DTE (DATE, FORMAT 'YYYY/MM/DD'),

But I am getting an error :

     RDBMS error 3706: Syntax error: Column name list is
                   invalid.

And, I have also tried as below .

     DTE_CRE  (DATE, FORMAT 'YYYYMMDD'),

     ORGN_PROV_DTE (DATE, FORMAT 'YYYYMMDD')

But the result is same ...I am getting the same Error.

Suggest me If I am wrong anywhere.

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