WHY is this so hard for me to grasp. I can use an SQL select statement to display a variable by simply using
,cast('2013-01-01' as date)
However, if I set that exact syntax to a variable
DECLARE @startdate Date = cast('2013-01-01' as date)
then try to display it in a select statment as
I get "Error: Arithmetic overflow error converting varchar to data type numeric"
I never used numeric. What gives??