Home Forums SQL Server 7,2000 T-SQL Cant format date for insert statement RE: Cant format date for insert statement
Aaron Templeton
SSCarpal Tunnel
Points: 4655
More actions
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)