where trunc(to_date(DATETIME,'yyyy-MM-dd hh24:mi:ss'))=trunc(sysdate) 转载于:https://www.cnblogs.com/gxivwshjj/p/4826600.html