Archives of the TeradataForum
Message Posted: Wed, 09 Oct 2001 @ 20:09:39 GMT
My first question is: are they allows leading zeroes?
If so, define the leading zeroes as junk char(??). Then, define the good data as a DECIMAL(??) and use it for the PI data for each row. Remember to ignore the junk.
If this (leading zeroes) is not the case, define it as two separate fields. Then, multiply the first field by 10000?? (whatever to account for digits) and add the two fields together. This is how Teradata handles a date for combining hours, minutes and seconds.
the problem here is that you might end up with a DECIMAL larger than 18 digits.
Best of luck,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|