Home Forums SQL Server 7,2000 Globalization The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. RE: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

  • Hi,

    Thanks for u'r quick reply.

    I think you have understood differently. My problem is "while inserting , i am getting the sql exception". But this is happening only in production server.

    I can't use the convert function because, i have around 50 pages in my application and have to use this convert function everywhere.

    Since it is working in my local server, I think this problem is due to some server settings.

    Please tell me where to change this settings...