我将日期存于Access后用 tempYear 2019 tempMonth 3 整数的方式来存
我在SQL写语法时
Select sum(销售额) From Table
Where ??
tempYear+tempMonth betwenn 2018/8 and 2019/3
我从外部传入了
StartYear=2018 StartMonth=8
EndYear=2019 EndMonth=3
我要怎么写入到SQL
不是mysql是Access来写
我将日期存于Access后用 tempYear 2019 tempMonth 3 整数的方式来存
我在SQL写语法时
Select sum(销售额) From Table
Where ??
tempYear+tempMonth betwenn 2018/8 and 2019/3
我从外部传入了
StartYear=2018 StartMonth=8
EndYear=2019 EndMonth=3
我要怎么写入到SQL
不是mysql是Access来写
string sql = string.Format("Select sum(销售额) From Table where 日期 between '{0}-{1}-1' and '{2}-{3}-1'", StartYear, StartMonth, EndYear, EndMonth);