Re: [SQL] About "Alter table... alter column.. TYPE ... "

2005-04-18 Thread Rod Taylor
> To alter table column from varchar(32) to date. "Alter table" command > does not seem to work: > > alter table test alter column col type date ; > ERROR: column "col1" cannot be cast to type "date" Alter table will not automatically throw away information. That is, in cases where it believes

[SQL] About "Alter table... alter column.. TYPE ... "

2005-04-18 Thread Ying Lu
Hello, To alter table column from varchar(32) to date. "Alter table" command does not seem to work: alter table test alter column col type date ; ERROR: column "col1" cannot be cast to type "date" Tks, Emi ---(end of broadcast)--- TIP 7: don't for