数据库CASE 函数 时间用法

select * from warehouse_trade_detail where
b_createtime>= cast('2016-01-01' as date) and
b_createtime<= cast('2017-02-28' as date)