select t.create_time from T_PLAT_ORDER t where TO_CHAR(t.create_time,'yyyy-MM-dd HH24:MI:SS') >= to_char(sysdate-30/(24*60),'yyyy-MM-dd HH24:MI:SS')