如以下代码:
$result =Db::table('users inner join ')->field('convert(varchar(100),logintime,20) logintime,convert(varchar(100),modifydate,20) modifydate')->select();
查询的filed里面出现了conver函数两次,结果出现了错误界面。查看生成的SQL语句发现,第二个convert函数莫名奇妙不见了!
sql语句如下:
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT convert(varchar(100),[logintime],20) logintime,[modifydate],20) modifydate FROM [users]) AS thinkphp) AS T
环境是SQLSERVER2012+TP5正式版。这个问题在测试版的时候还不存在的。
最佳答案