|
![](static/image/common/ico_lz.png)
楼主 |
发表于 2020-12-18 19:45:01
|
显示全部楼层
sql.Format("select start_time,end_time from leave_info_tab "
"where personID='%s'and "
"start_time> (convert(datetime,'yyyy-mm-dd' )) "
"and end_time<(convert(datetime,'yyyy-mm-dd' )) ",
strPersonID,strMonthStart,strMonthEnd);
这是里面的一部分语句,出现错误提示从字符转换成datetime时发生错误
|
|