Post reply

The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. The statement has been terminated.

  • March 27, 2011 at 7:37 am

    #236855

    I am using windows 7 professional. I have configured local host when i try to log in the webapplication it shows the following error message

    "The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. The statement has been terminated."

    the same website working in windows xp and windows 2000 perfectly and using the date format as "dd/mm/yyyy". pls. give me solution to rectify this

    in the window 7 the following are the settings

    short date 27/03/2011

    long date 27 March 2011

    short time 19:05

    Long Time 19:05:50

    regards

    vinayan

  • March 27, 2011 at 7:56 am

    #1304057

    Use convert to specify the format, SQL's probably assuming it's mm/dd/yyyy, or switch to a data format that can't be confused - yyyy/mm/dd

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply