to_char(kh.createDate,'yyyy-mm-dd')=:createDate"
转载于:https://www.cnblogs.com/yanjunwu/archive/2013/05/31/3109816.html