oracle相关

1、String->日期向转

SELECT
    tc.OPERATOR_USERNAME AS OPERATOR_NO,
    tc.OPERATOR_NAME AS OPERATOR_CN_NAME,
    tc.OPERATOR_ORG AS OPERATOR_ORG_KEY,
    count( tc.OPERATOR_USERNAME ) AS SUM_CP 
FROM
    INHERENT_RISK_ASSESSMENT tc 
WHERE
    tc.OPERATOR_USERNAME IS NOT NULL 
    AND TASK_STATUS IN ( 'F_RA2', 'F_RA3', 'F_RA5', 'F_RA4' ) 
    AND tc.SUBMIT_DATE BETWEEN TO_DATE( '2021-09-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS' ) 
    AND TO_DATE( '2021-09-30 23:59:59', 'SYYYY-MM-DD HH24:MI:SS' ) 
GROUP BY
    tc.OPERATOR_USERNAME,
    tc.OPERATOR_ORG;