Home Forums SQL Server 2005 T-SQL (SS2K5) Convert Varchar to datetime RE: Convert Varchar to datetime

  • February 11, 2010 at 3:10 pm

    #1117803

    CooLDBA (2/11/2010)

    I was able to change the data to

    08-24-2004

    08-25-2004

    08-26-2004

    select CONVERT(datetime, F3, 103) from _CalendarDate

    Msg 242, Level 16, State 3, Line 1

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

    (1 row(s) affected)

    any clue?

    try this:

    select CONVERT(datetime, F3, 110) from _CalendarDate