 |
 |
Archives of the TeradataForum
Message Posted: Wed, 25 Aug 2004 @ 14:32:27 GMT
| Subj: | | Re: Overflow error and time(0) |
| |
| From: | | Victor Sokovin |
| | Thanks, That worked. But casting timestamp(6) to char(26) and then casting it to time(0) is taking extra 3 mintues. Is there any reason?.
I have 101 million records in the table. | |
Such conversions always cost extra CPU time. Perhaps you could save some time by casting to char(19). In my example current_timestamp was
also with 6 decimals and the code worked. You might need to check whether the rounding works as you expect.
Victor
| |
