|
|
Archives of the TeradataForum
Message Posted: Tue, 05 Dec 2006 @ 11:33:31 GMT
Subj: | | Re: Handling 21 digits in Teradata |
|
From: | | Victor Sokovin |
| Why don't you store it as a varchar and then do a CAST for your computations? | |
Randall, it is probably because CAST is not more powerful than the database itself. CAST does not open any new possibilities.
For what it might be worth, I think there is not much to add to what the OP had already summarized. Perhaps only a joke. As the OP mentioned
the data is financial. Unless it is all in some exotic currency a shop requiring calculations in 21,2 format can afford an early upgrade to the TD
version supporting such calculations or even sponsor faster development in this area.
Regards,
Victor
| |