Syntax error converting datetime fom character string

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • SnehaAgrawal
    New Member
    • Apr 2009
    • 31

    Syntax error converting datetime fom character string

    Hi I get the error "Syntax error converting datetime from character string "for
    the following sql statement in Stored proc.

    SET @dynamicSQL =N'SELECT CUSTID,SHCodeLi nk FROM AccountMaster where CONVERT(DATETIM E,OPDATE,105) < = '''+CONVERT(DAT ETIME,@ACCYEAR, 105) +''' And GLCode = '+@DIVGLCODE

    EXEC(@dynamicsq l)
  • code green
    Recognized Expert Top Contributor
    • Mar 2007
    • 1726

    #2
    It is usually a stray quotation -
    that is quotes where they shouldn't be or vice-versa.
    Can't tell from your post because you haven't wrapped in CODE.

    Comment

    Working...