final Date date = toDate(str, format);
            if (date != null) {
                return new java.sql.Date(date.getTime());
            }
        }
        final Date date = toDate(str, locale);
        if (date != null) {
            return new java.sql.Date(date.getTime());
        }
        final java.sql.Date sqlDate = toSqlDateJdbcEscape(str);
        if (sqlDate != null) {
            return sqlDate;

        case Long l -> l;
        case Number n -> n.longValue();
        case String s -> toLong(s);
        case java.util.Date d -> pattern != null ? Long.valueOf(new SimpleDateFormat(pattern).format(d)) : d.getTime();
        case Boolean b -> b ? 1L : 0L;
        default -> toLong(o.toString());
        };
    }

    private static Long toLong(final String s) {
        if (StringUtil.isEmpty(s)) {
            return null;

        case TIME_1970_SEC_32BE -> enc_uint32be((int) (date.getTime() / 1000L), dst, di);
        case TIME_1970_SEC_32LE -> enc_uint32le((int) (date.getTime() / 1000L), dst, di);
        case TIME_1904_SEC_32BE -> enc_uint32be((int) (date.getTime() / 1000L + SEC_BETWEEEN_1904_AND_1970 & 0xFFFFFFFF), dst, di);
        case TIME_1904_SEC_32LE -> enc_uint32le((int) (date.getTime() / 1000L + SEC_BETWEEEN_1904_AND_1970 & 0xFFFFFFFF), dst, di);

            if (pattern != null) {
                return Float.valueOf(new SimpleDateFormat(pattern).format(o));
            }
            return Float.valueOf(((java.util.Date) o).getTime());
        } else {
            return toFloat(o.toString());
        }
    }

    private static Float toFloat(final String s) {
        if (StringUtil.isEmpty(s)) {
            return null;
        }

        case TIME_1970_SEC_32BE -> enc_uint32be((int) (date.getTime() / 1000L), dst, di);
        case TIME_1970_SEC_32LE -> enc_uint32le((int) (date.getTime() / 1000L), dst, di);
        case TIME_1904_SEC_32BE -> enc_uint32be((int) (date.getTime() / 1000L + SEC_BETWEEEN_1904_AND_1970 & 0xFFFFFFFF), dst, di);
        case TIME_1904_SEC_32LE -> enc_uint32le((int) (date.getTime() / 1000L + SEC_BETWEEEN_1904_AND_1970 & 0xFFFFFFFF), dst, di);

        case Integer i -> i;
        case Number n -> n.intValue();
        case String s -> toInteger(s);
        case java.util.Date d -> pattern != null ? Integer.valueOf(new SimpleDateFormat(pattern).format(d)) : (int) d.getTime();
        case Boolean b -> b ? 1 : 0;
        default -> toInteger(o.toString());
        };
    }

    private static Integer toInteger(final String s) {
        if (StringUtil.isEmpty(s)) {

            if (pattern != null) {
                return Double.valueOf(new SimpleDateFormat(pattern).format(o));
            }
            return Double.valueOf(((java.util.Date) o).getTime());
        } else {
            return toDouble(o.toString());
        }
    }

    private static Double toDouble(final String s) {
        if (StringUtil.isEmpty(s)) {
            return null;
        }

        } else if (o instanceof java.util.Date) {
            if (pattern != null) {
                return Byte.valueOf(new SimpleDateFormat(pattern).format(o));
            }
            return (byte) ((java.util.Date) o).getTime();
        } else if (o instanceof Boolean) {
            return ((Boolean) o) ? (byte) 1 : (byte) 0;
        } else {
            return toByte(o.toString());
        }
    }

        } else if (o instanceof java.util.Date) {
            if (pattern != null) {
                return Short.valueOf(new SimpleDateFormat(pattern).format(o));
            }
            return (short) ((java.util.Date) o).getTime();
        } else if (o instanceof Boolean) {
            return ((Boolean) o) ? (short) 1 : (short) 0;
        } else {
            return toShort(o.toString());
        }
    }

            final Date date = toDate(str, format);
            if (date != null) {
                return new Time(date.getTime());
            }
        }
        final Date date = toDate(str, locale);
        if (date != null) {
            return new Time(date.getTime());
        }
        final Time time = toSqlTimeJdbcEscape(str);
        if (time != null) {
            return time;
        }