 |
 |
Archives of the TeradataForum
Message Posted: Thu, 30 Sep 2004 @ 15:14:06 GMT
| Subj: | | Re: Timestamp(0) |
| |
| From: | | Victor Sokovin |
| | I have a timestamp(6) column on a table but I don't want to display the fractional part of the seconds when I do a select. | |
| | I was hoping I could just re cast it as timestamp(0) but I get error 7454 "date time field overflow". Is there a way of doing this without
having to cast to CHAR and subsequently substr | |
We had a go on this a month ago:
www.teradataforum.com/teradata/20040825_075858.htm.
At that time nobody proposed a better solution. Let's see whether the situation changed.
Regards,
Victor
| |
