Archives of the TeradataForum
Message Posted: Sun, 10 Feb 2013 @ 08:52:46 GMT
<-- 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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|