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.

  • June 24, 2009 at 3:35 am

    #1014495

    try

    convert(datetime,'date',101)

    ----------------------------------------------------------------------------------------------------------------------------------------------------
    Roshan Joe

    Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]