Re: [SQL] cannot alter column data type to "date"

2005-12-07 Thread Michael Fuhr
On Thu, Dec 08, 2005 at 03:12:07PM +0800, Noel Doydora wrote: > Below is the message I receive when I try to alter the data type of > a column to "date". I had to drop the column and add it again just > so I can set its data type to "date". How do I change a column's > data type to "date" withou

[SQL] cannot alter column data type to "date"

2005-12-07 Thread Noel Doydora
Below is the message I receive when I try to alter the data type of a column to "date". I had to drop the column and add it again just so I can set its data type to "date". How do I change a column's data type to "date" without dropping and then creating it again? Hoping for a kind response. Th