July 5, 2001 at 7:27 pm
I am trying to change field type from 'char' to 'datetime', the enterprise manager gives
error message stating
"- Unable to modify table.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
I have 'null value for that field in all records.
Please copy me at jocollin@czn.com also.
July 5, 2001 at 8:05 pm
Have you tried checking if there is a default or FK bound? Cascading updates?
Steve Jones
July 6, 2001 at 7:14 am
I would guess that you've got a value that SQL can't translate to a date. Try making a separate col that is a datetime, then update it with the contents of your char field. That would eliminate any questions about fkeys or cascades.
Andy
July 6, 2001 at 11:01 am
Thanks guys. The suggestion by Andy Warren worked. I recreated a new one, deleted the old column and the datetime field is working now.
July 6, 2001 at 11:17 am
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy