Home Forums SQL Server 7,2000 T-SQL getdate() in dynamic SQL RE: getdate() in dynamic SQL

  • May 27, 2008 at 2:17 am

    #820405

    smknox (5/26/2008)

    I would like to use the value of GetDate() within a dynamic SQL statement.

    THe following line:

    ', DateUpdated = '+ GetDate()+ CHAR(13)+

    produces a syntax error "error converting datetime from character string"

    Thanks for the help.

    Sam

    Try This

    ', DateUpdated = '''+ CONVERT(VARCHAR(12),GETDATE(),101)+''''+ CHAR(13) +

    Prasad Bhogadi
    www.inforaise.com