ALTER table

[bitwise]

What is the syntax for the ALTER TABLE command to change a columns data type in a table from a 'timestamp' to a 'datetime'?

Thanks,
-bitwise

 

[Cagliostro]

alter table xxx alter column .... Ion Filipski

filipski@excite.com

 

[bitwise]

Yeah, I've tried that it says:

"Cannot alter column 'Field_Name' because it is 'timestamp'."

What does that mean? Why doesn't it allow you to change the timestamp type?

-bitwise

PS: Here is the statement:
alter table Table_Name alter column Field_Name datetime

 

[dbmsguy]

true enough, not supported....

you could however add a new column for the timestamp field and then drop the timestamp column.... this would work. if you needed the column to be the same name, you could then rename the column to the proper name after adding it as something else.

remember a timestamp column does not have an actual time in it. just a system generated number, so the values in it are irrellevant. Paul

http://www.dbmsguy.com