Archives of the TeradataForum

Message Posted: Tue, 19 Oct 2010 @ 09:02:36 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Madhu,

Time zone is optional part not in only TIMESTAMP. It has to be in "TIMESTAMP WITH TIME ZONE". The literal you are providing in default clause have only timestamp for recognizing it.

For your problem: Before creating the table issue a "SET SESSION" command to set the time zone, then create the table. Ex-

     SET TIME ZONE '+07:00';

     create table Temp(
        c1 integer,
        c8 timestamp with time zone
              FORMAT 'YYYY-MM-DDBHH:MI:SS.S(6)BZ'
              NOT NULL
              DEFAULT timestamp '1997-09-24 11:37:58.224332'
     );

     show table TPALLTYPE2;

Then reset the session zone value. This way you can insert the zone value in your default clause.

Hope this helps!!

regards,

Sudhansu

	<Prev	Next>		<<First	<Prev	Next>	Last>>