Archives of the TeradataForum
Message Posted: Thu, 27 Aug 2015 @ 14:25:16 GMT
You have some syntax issues. There should be a space between DD and HH, no dash. There should be semi colons between HH and MI and SS. See below.
create table test ( mytp TIMESTAMP(6) NOT NULL FORMAT 'YYYY-MM-DD HH:MI:SS.S(6)' DEFAULT TIMESTAMP '9999-12-31 01:01:01.000001' );
Kevin R Tewksbury
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|