Archives of the TeradataForum

Message Posted: Mon, 26 Feb 2007 @ 16:53:31 GMT

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

Hi,

Follow following steps:

     1. Create table tbl (pi_col integer,     Date_col date);

     2. insert into tbl
        values (1, date);

     insert into tbl
     values (2, date-2);

     insert into tbl
     values (1, date-3);


     sel * from tbl;

     3.  Alter table tbl

         Add timestamp_col timestamp(0);

     4.  update tbl

         set timestamp_col = cast(date_col as timestamp(0));

     5. alter table tbl

      drop column date_col;

     6. alter table tbl rename timestamp_col to date_col;

Hope it answers your question.

thanks & regards

Prahlad Patidar

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