oracle查询某天的数据

oracle中日期是date类型，需要转化为字符类型，方便比较

1、使用to_char  

select distinct ss.wano, ss.pickedwho
   from act_allocation_d ss
   left join doc_order d
     on ss.orderno = d.orderno
  where d.warehouseid = '022DCX'
    and to_char(ss.pickedtime,'yyyy/mm/dd') =  '2021/10/27';

2、使用trunc

select distinct ss.wano, ss.pickedwho
   from act_allocation_d ss
   left join doc_order d
     on ss.orderno = d.orderno
  where d.warehouseid = '022DCX'
     and trunc(ss.pickedtime) =  to_date('2021/10/27','yyyy/mm/dd');

注意

有时trunc截取的带：2021/10/27 00:00:00

导致匹配失效，建议最好用to_char