Archives of the TeradataForum
Message Posted: Thu, 15 May 2003 @ 09:33:27 GMT
The following works. (It ain't pretty but it works).
create table t1 (c1 timestamp(0));
I've never found an easy way of converting between different Timestamp formats. I always end up (as above) casting to CHAR, substring to get the correct data nd then casting back into the new timestamp data type.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|