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
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
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
Glad we could help.
Steve Jones
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply