select * from ceshi1 where paytime in ('${paytime}')这条语句是绑定参数的sql语句,我的paytime字段存储的是时间戳int类型,直接这么写肯定是不行的,日期组件不识别,哪位大佬告诉下该怎么写,帮忙写在下面,先感谢了!
cast(cast(paytime as nvarchar) as date)
select * from ceshi1 where paytime ='${DATETONUMBER(paytime)/1000}'