Null in Datetime field

• graceb

  Right there with Babe

  Points: 734

  More actions

  July 5, 2001 at 7:27 pm

  #77216

  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.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738337

  More actions

  July 5, 2001 at 8:05 pm

  #416946

  Have you tried checking if there is a default or FK bound? Cascading updates?

  Steve Jones

  steve@dkranch.net

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  July 6, 2001 at 7:14 am

  #416948

  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

  Andy
  Connect with me on LinkedIn

• graceb

  Right there with Babe

  Points: 734

  More actions

  July 6, 2001 at 11:01 am

  #416951

  Thanks guys. The suggestion by Andy Warren worked. I recreated a new one, deleted the old column and the datetime field is working now.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738337

  More actions

  July 6, 2001 at 11:17 am

  #416952

  Glad we could help.

  Steve Jones

  steve@dkranch.net