public static String removeZone()

in eventmesh-connectors/eventmesh-connector-canal/src/main/java/org/apache/eventmesh/connector/canal/SqlUtils.java [466:504]


    public static String removeZone(String datetime) {
        if (datetime == null || datetime.length() == 0) {
            return datetime;
        }
        int len = datetime.length();
        if (datetime.charAt(len - 1) == 'Z' || datetime.charAt(len - 1) == 'z') {
            return datetime.substring(0, len - 1).trim();
        }
        if (len >= 7) {
            char checkCharAt1 = datetime.charAt(len - 2);
            if ((checkCharAt1 == '+' || checkCharAt1 == '-') && len >= 10) {
                return datetime.substring(0, len - 2).trim();
            }
            char checkCharAt2 = datetime.charAt(len - 3);
            if ((checkCharAt2 == '+' || checkCharAt2 == '-') && len >= 11) {
                return datetime.substring(0, len - 3).trim();
            }
            char checkCharAt3 = datetime.charAt(len - 6);
            if ((checkCharAt3 == '+' || checkCharAt3 == '-') && checkCharAt2 == ':') {
                return datetime.substring(0, len - 6).trim();
            }
            char checkCharAt4 = datetime.charAt(len - 5);
            if ((checkCharAt4 == '+' || checkCharAt4 == '-') && checkCharAt2 == ':') {
                return datetime.substring(0, len - 5).trim();
            }
            char checkCharAt5 = len >= 9 ? datetime.charAt(len - 9) : ' ';
            if ((checkCharAt5 == '+' || checkCharAt5 == '-') && checkCharAt2 == ':' && checkCharAt3 == ':') {
                return datetime.substring(0, len - 9).trim();
            }
            char checkCharAt6 = datetime.charAt(len - 7);
            if (checkCharAt6 == '+' || checkCharAt6 == '-') {
                return datetime.substring(0, len - 7).trim();
            }
            if (checkCharAt4 == '+' || checkCharAt4 == '-') {
                return datetime.substring(0, len - 5).trim();
            }
        }
        return datetime;
    }