assertThat(new SimpleDateFormat("yyyy/MM/dd").format(calendar.getTime()), is("2010/09/07"));
    }

    /**
     * @throws Exception
     */
    @Test
    public void testToCalendar_MediumStyle() throws Exception {
        final Calendar calendar = toCalendar("2010/9/7");
        assertThat(new SimpleDateFormat("yyyy/MM/dd").format(calendar.getTime()), is("2010/09/07"));
    }

    /**
     * @throws Exception

        assertThat(new SimpleDateFormat("HH:mm:ss").format(calendar.getTime()), is("11:49:00"));
    }

    /**
     * @throws Exception
     */
    @Test
    public void testToCalendar_MediumStyle() throws Exception {
        final Calendar calendar = toCalendar("11:49:10");
        assertThat(new SimpleDateFormat("HH:mm:ss").format(calendar.getTime()), is("11:49:10"));
    }

    /**
     * @throws Exception

    }

    /**
     * @throws Exception
     */
    @Test
    public void testToCalendar_MediumStyle() throws Exception {
        final Calendar calendar = toCalendar("2010/9/7 11:49:10", Locale.JAPAN);
        assertThat(new SimpleDateFormat("yyyy/MM/dd HH:mm:ss").format(calendar.getTime()), is("2010/09/07 11:49:10"));
    }

    /**

            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)) {

            cal.set(Calendar.HOUR_OF_DAY, 0);
            cal.set(Calendar.MINUTE, 0);
            cal.set(Calendar.SECOND, 0);
            cal.set(Calendar.MILLISECOND, 0);

            if (cal.getTime().after(lastModified)) {
                checkForUpdates = true;
            }
        } else if (updatePolicy.startsWith(UPDATE_POLICY_INTERVAL)) {