----------------------------选出当月的记录-------------------------------------------------------------------- select * from warehouse_work where putin_time> convert(datetime,substring(convert(varchar(10), getdate(), 120),1,8)+'01' ) -------------------------------------------------------------------------------------------------------------- select * from warehouse_work where substring(convert(varchar(10), putin_time, 120),1,8) like (substring(convert(varchar(10), getdate(), 120),1,8))
Sql中查询本月数据字段的表示方法
最新推荐文章于 2021-07-30 18:13:57 发布