Archives of the TeradataForum

Message Posted: Sun, 10 Feb 2013 @ 08:52:46 GMT

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

<-- Anonymously Posted: Saturday, February 09, 2013 11:15 -->

in mapping doc we have the following Rule to load the date. This can be derived from the Julian date (JJJ) and year (YY)on the source column: RRYYJJJBBBSSS.

When I ran the sql I got this result

     SEL SUBSTR(cld.sourcecol ,3,5) AS xyz,
     xyz (DATE,FORMAT'yyddd') AS bb,
     cld.sourcecol

     FROM ProdDb.source_tbl cld

     12121   1912-04-30   2012129999999
     12128   1912-05-07   991212999xxxx

So this shows when I am converting into regular date from 'yymmm' , its assuming the 20th century .

Teradata expect us to use 'yyyy' instead of 'yy' fields for 21st century. But as clear from the Mapping Rule we have only yy available which is insufficient information

Can some body suggest How to code this.

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