Home Forums SQL Server 7,2000 T-SQL Cant format date for insert statement RE: Cant format date for insert statement

  • September 23, 2004 at 12:22 pm

    #524238

    @NEXT_YEAR is an integer and causes string concatenation problems. CAST or CONVERT it to a varchar.

    '7/1/' + CONVERT(varchar, @NEXT_YEAR),

    '7/31/' + CONVERT(varchar, @NEXT_YEAR)