oracle中带有年月日时分秒的日期查询

SELECT T1.BATCH_ID ,
T1.CREATE_DATE ,
T1.START_DATE ,
T1.END_DATE ,
T1.TOTAL_NUMBER ,
T1.SUCCESS_NUMBER ,
T1.ERROR_NUMBER ,
T1.EMP_NAME ,
T1.PROCESS_KBN ,
T1.DATA_TYPE ,
T1.SAVE_FILE_NAME ,
T1.DELETED_FLG ,
T1.SEND_MAIL_FLG ,
T1.SAVE_FOLDER_NAME ,
T1.SAVE_FILE_DEL_FLG ,
T1.BATCH_FLG
FROM IFLOG.MOD_COMPANY_BATCH T1
WHERE ROWNUM < '100'
AND T1.CREATE_DATE BETWEEN to_date('2012/10/12 15:05:18','YYYY/MM/DD HH24:MI:SS') AND to_date('2012/11/06 11:49:11','YYYY/MM/DD HH24:MI:SS')
ORDER BY BATCH_ID DESC;