SELECT * FROM TB_YOFISHDK_ORDER_LOAN_INFO WHERE TO_CHAR(ACCOUNT_TIME,'yyyymmddhhmmss') >'20181120000028' AND TO_CHAR(ACCOUNT_TIME,'yyyymmddhhmmss') < '20181121000028';
Oracle查询语句报无效的月份
最新推荐文章于 2024-08-17 15:34:18 发布
SELECT * FROM TB_YOFISHDK_ORDER_LOAN_INFO WHERE TO_CHAR(ACCOUNT_TIME,'yyyymmddhhmmss') >'20181120000028' AND TO_CHAR(ACCOUNT_TIME,'yyyymmddhhmmss') < '20181121000028';