Oracle

to_char:

select * from table where '2021-08-11' = to_char(colum,'yyyy-MM-dd')`

to_date:

 select * from table where colum >= to_date('2021-08-11'||' 00:00:00','yyyy-MM-dd hh24:mi:ss')

执行存储过程：

call  FIX_AUTO_UPDATE();

查询锁表

select t2.sid,  t2.serial#, t1.*,t2.* from v$locked_object t1,v$session t2 where t1.session_id=t2.sid order by t2.logon_time;

解锁

alter system kill session '946,19411';

恢复快照

alter table tableName enable row movement;

flashback table tableName to timestamp TO_TIMESTAMP('2021-08-18 17:15:00','yyyy-mm-dd hh24:mi:ss');

alter table tableName disable row movement;

存储过程中查日期

REQUESTEDSHIPDATE=to_date(item.c,'YYYY-MM-DD HH24:MI:SS')