select
      *
    from LG_GNLKXX_TEMP
    where
    delete_state =0 and (RZLX = 0 or RZLX = 1)
    and create_date >= to_date(to_char(sysdate-10/(24*60),'yyyy-mm-dd hh24:mi:ss'),'yyyy-mm-dd hh24:mi:ss')
    and create_date <= to_date(to_char(sysdate,'yyyy-mm-dd hh24:mi:ss'),'yyyy-mm-dd hh24:mi:ss')

 

转载于:https://my.oschina.net/u/3023191/blog/1838832

Logo

北京人形旗下天工造物具身智能开源社区,聚焦具身天工与慧思开物两大平台

更多推荐