Archives of the TeradataForum
Message Posted: Thu, 15 May 2003 @ 11:27:04 GMT
| Subj: | | Re: Inserting Timestamps using Queryman |
| |
| From: | | Dieter N�th |
David Wellman wrote:
| | The following works. (It ain't pretty but it works). | |
| | create table t1 (c1 timestamp(0));
insert into t1 values( cast(substring(cast(current_timestamp
as char(32)) from 1 for 19) as timestamp(0)) ); | |
insert into t1 values(current_timestamp(0));
The problem is _not_ the timezone, it's the default seconds precision of 6.
| | I've never found an easy way of converting between different Timestamp formats. | |
You can't cast precision to be less than the original timestamp, this is probably due to ANSI SQL restrictions. I looked at the SQL:1999
standard, but really didn't understand it ;-)
Dieter
| 
