|
|
Archives of the TeradataForum
Message Posted: Mon, 21 May 2001 @ 13:47:28 GMT
Subj: | | Re: Defaults for Date and Time columns |
|
From: | | Geoffrey Rommel |
Anomy Anom writes:
| The CREATE_DATE column works just fine. However, I get a 3630 error on the CREATE_TIME column. If I drop the default from the
CREATE_TIME column , the table gets created just fine, but I can't figure out what format of the time I should supply on an insert. I
created the column as TIME(0), and tried inserting values '12:01:01', '12.01.01', '120101', and 120101. Each time, the insert fails with a
5407 error. We are running in Teradata mode, if that makes any difference. | |
In Teradata mode on V2R3, this works for me:
insert into my.table
values(1, time '12:01:01');
This forces Teradata to treat the string as an ANSI time literal rather than a character string.
| |