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

  • February 11, 2010 at 3:58 pm

    #1117821

    Msg 241, Level 16, State 1, Line 1

    Syntax error converting datetime from character string.

    It didn't make sense as if I do:

    SELECT convert(datetime,'2004-08-24',120)

    2004-08-24 00:00:00.000

    It works!