oralce date类型 between

2023-08-26 44 阅读1分钟

   select * from   wssyjx.task_record r where 
   cjsj between TO_TIMESTAMP('2023/8/26 13:40:14','yyyy/mm-dd HH24:mi:ss')
   and  TO_TIMESTAMP('2023/8/26 13:59:14','yyyy/mm-dd HH24:mi:ss')