Question

下面存储过程，定义游标，哪里的错？提示“参数数据类型 varchar 对于 convert 函数的参数 3 无效。”

declare CurOut Cursor for select CONVERT(int,substring(LOG_TIME,1,2))hho,CONVERT(int,substring(LOG_TIME,4,2)) mmo,CONVERT(int,substring(LOG_TIME,7,2)) sso,
MODULE_NAME,INPUT_TIME from LOG_LICENCEDATA
where INPUT_TIME between CONVERT(DATETIME, @Today,'yyyy-MM-dd') and CONVERT(DATETIME, @endtime,'yyyy-MM-dd')
and USER_NAME=@nameuser and USER_COPMUTER=@usercomputer and LICENCE_SERVER=@licenceserver and (USER_ACTION like '%OUT%' or USER_ACTION like '%logout%') order by INPUT_TIME asc;

Answer 1

查询条件里面的
CONVERT(DATETIME, @Today,'yyyy-MM-dd') and CONVERT(DATETIME, @endtime,'yyyy-MM-dd')

这里的写法错了
CONVERT没有这种用法

你可以改成
CONVERT(varchar(10),@Today,120) and CONVERT(varchar(10),@endtime,120)