Values_AreClose_Object_And_DateTimeValue_Test.java

/**
 * Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with
 * the License. You may obtain a copy of the License at
 *
 * http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on
 * an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the
 * specific language governing permissions and limitations under the License.
 *
 * Copyright 2012-2016 the original author or authors.
 */
package org.assertj.db.util;

import org.assertj.db.common.AbstractTest;
import org.assertj.db.type.DateTimeValue;
import org.assertj.db.type.DateValue;
import org.assertj.db.type.TimeValue;
import org.junit.Test;

import java.sql.Date;
import java.sql.Timestamp;

import static org.assertj.core.api.Assertions.assertThat;

/**
 * Tests on {@code areClose} method for {@code DateTimeValue}s.
 *
 * @author Régis Pouiller
 *
 */
public class Values_AreClose_Object_And_DateTimeValue_Test extends AbstractTest {

  /**
   * This method tests the {@code areClose} method for {@code DateTimeValue}s.
   */
  @Test
  public void test_are_close_for_timestamps_with_date() throws Exception {
    assertThat(
            Values.areClose(getValue(null, Timestamp.valueOf("2007-12-23 09:01:06.000000003")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(9, 1, 6, 3)), DateValue.of(0, 0, 0))).isTrue();
    assertThat(
            Values.areClose(getValue(null, Timestamp.valueOf("2007-12-23 09:01:06.000000003")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(9, 1, 5, 3)), DateValue.of(0, 0, 0))).isFalse();
    assertThat(Values.areClose(getValue(null, ""),
                               DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(9, 1, 6, 3)), DateValue.of(0, 0, 0)))
            .isFalse();
    assertThat(Values.areClose(getValue(null, Timestamp.valueOf("2007-12-23 09:01:06.000000003")), (DateTimeValue) null, DateValue.of(0, 0, 0)))
            .isFalse();

    assertThat(
            Values.areClose(getValue(null, Timestamp.valueOf("2007-12-23 09:01:06.000000003")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(9, 1, 6, 2)), DateValue.of(0, 0, 0))).isFalse();
    assertThat(
            Values.areClose(getValue(null, Timestamp.valueOf("2007-12-23 09:01:06.000000003")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(9, 1, 5, 3)), DateValue.of(0, 0, 0))).isFalse();
    assertThat(
            Values.areClose(getValue(null, Timestamp.valueOf("2007-12-23 09:01:06.000000003")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(9, 2, 6, 3)), DateValue.of(0, 0, 0))).isFalse();
    assertThat(
            Values.areClose(getValue(null, Timestamp.valueOf("2007-12-23 09:01:06.000000003")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(10, 1, 6, 3)), DateValue.of(0, 0, 0))).isFalse();
    assertThat(
            Values.areClose(getValue(null, Timestamp.valueOf("2007-12-23 09:01:06.000000003")),
                            DateTimeValue.of(DateValue.of(2007, 12, 3), TimeValue.of(9, 1, 6, 3)), DateValue.of(0, 0, 0))).isFalse();
    assertThat(
            Values.areClose(getValue(null, Timestamp.valueOf("2007-12-23 09:01:06.000000003")),
                            DateTimeValue.of(DateValue.of(2007, 2, 23), TimeValue.of(9, 1, 6, 3)), DateValue.of(0, 0, 0))).isFalse();
    assertThat(
            Values.areClose(getValue(null, Timestamp.valueOf("2007-12-23 09:01:06.000000003")),
                            DateTimeValue.of(DateValue.of(2008, 12, 23), TimeValue.of(9, 1, 6, 3)), DateValue.of(0, 0, 0))).isFalse();

    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23)), DateValue.of(0, 0, 0))).isTrue();
    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(9, 1, 5, 3)), DateValue.of(0, 0, 0))).isFalse();
    assertThat(Values.areClose(getValue(null, ""),
                               DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(9, 1, 6, 3)), DateValue.of(0, 0, 0))).isFalse();
    assertThat(Values.areClose(getValue(null, Date.valueOf("2007-12-23")), (DateTimeValue) null, DateValue.of(0, 0, 0))).isFalse();

    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(9, 1, 6, 2)), DateValue.of(0, 0, 0))).isFalse();
    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(9, 1, 5, 3)), DateValue.of(0, 0, 0))).isFalse();
    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(9, 2, 6, 3)), DateValue.of(0, 0, 0))).isFalse();
    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(10, 1, 6, 3)), DateValue.of(0, 0, 0))).isFalse();
    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2007, 12, 3), TimeValue.of(9, 1, 6, 3)), DateValue.of(0, 0, 0))).isFalse();
    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2007, 2, 23), TimeValue.of(9, 1, 6, 3)), DateValue.of(0, 0, 0))).isFalse();
    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2008, 12, 23), TimeValue.of(9, 1, 6, 3)), DateValue.of(0, 0, 0))).isFalse();

    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(9, 1, 6, 2)), DateValue.of(0, 0, 1))).isTrue();
    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(9, 1, 5, 3)), DateValue.of(0, 0, 1))).isTrue();
    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(9, 2, 6, 3)), DateValue.of(0, 0, 1))).isTrue();
    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(10, 1, 6, 3)), DateValue.of(0, 0, 1))).isTrue();
    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2007, 12, 3), TimeValue.of(9, 1, 6, 3)), DateValue.of(0, 0, 20))).isTrue();
    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2007, 2, 23), TimeValue.of(9, 1, 6, 3)), DateValue.of(0, 10, 0))).isTrue();
    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2008, 12, 23), TimeValue.of(9, 1, 6, 3)), DateValue.of(1, 0, 1))).isTrue();
  }

  /**
   * This method tests the {@code areClose} method for {@code DateTimeValue}s.
   */
  @Test
  public void test_are_close_for_timestamps_with_time() throws Exception {
    assertThat(
            Values.areClose(getValue(null, Timestamp.valueOf("2007-12-23 09:01:06.000000003")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(9, 1, 6, 3)), TimeValue.of(0, 0, 0))).isTrue();
    assertThat(
            Values.areClose(getValue(null, Timestamp.valueOf("2007-12-23 09:01:06.000000003")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(9, 1, 5, 3)), TimeValue.of(0, 0, 0))).isFalse();
    assertThat(Values.areClose(getValue(null, ""),
                               DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(9, 1, 6, 3)), TimeValue.of(0, 0, 0)))
            .isFalse();
    assertThat(Values.areClose(getValue(null, Timestamp.valueOf("2007-12-23 09:01:06.000000003")), (DateTimeValue) null, TimeValue.of(0, 0, 0)))
            .isFalse();

    assertThat(
            Values.areClose(getValue(null, Timestamp.valueOf("2007-12-23 09:01:06.000000003")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(9, 1, 6, 2)), TimeValue.of(0, 0, 0))).isFalse();
    assertThat(
            Values.areClose(getValue(null, Timestamp.valueOf("2007-12-23 09:01:06.000000003")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(9, 1, 5, 3)), TimeValue.of(0, 0, 0))).isFalse();
    assertThat(
            Values.areClose(getValue(null, Timestamp.valueOf("2007-12-23 09:01:06.000000003")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(9, 2, 6, 3)), TimeValue.of(0, 0, 0))).isFalse();
    assertThat(
            Values.areClose(getValue(null, Timestamp.valueOf("2007-12-23 09:01:06.000000003")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(10, 1, 6, 3)), TimeValue.of(0, 0, 0))).isFalse();
    assertThat(
            Values.areClose(getValue(null, Timestamp.valueOf("2007-12-23 09:01:06.000000003")),
                            DateTimeValue.of(DateValue.of(2007, 12, 3), TimeValue.of(9, 1, 6, 3)), TimeValue.of(0, 0, 0))).isFalse();
    assertThat(
            Values.areClose(getValue(null, Timestamp.valueOf("2007-12-23 09:01:06.000000003")),
                            DateTimeValue.of(DateValue.of(2007, 2, 23), TimeValue.of(9, 1, 6, 3)), TimeValue.of(0, 0, 0))).isFalse();
    assertThat(
            Values.areClose(getValue(null, Timestamp.valueOf("2007-12-23 09:01:06.000000003")),
                            DateTimeValue.of(DateValue.of(2008, 12, 23), TimeValue.of(9, 1, 6, 3)), TimeValue.of(0, 0, 0))).isFalse();

    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23)), TimeValue.of(0, 0, 0))).isTrue();
    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(9, 1, 5, 3)), TimeValue.of(0, 0, 0))).isFalse();
    assertThat(Values.areClose(getValue(null, ""),
                               DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(9, 1, 6, 3)), TimeValue.of(0, 0, 0))).isFalse();
    assertThat(Values.areClose(getValue(null, Date.valueOf("2007-12-23")), (DateTimeValue) null, TimeValue.of(0, 0, 0))).isFalse();

    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(9, 1, 6, 2)), TimeValue.of(0, 0, 0))).isFalse();
    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(9, 1, 5, 3)), TimeValue.of(0, 0, 0))).isFalse();
    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(9, 2, 6, 3)), TimeValue.of(0, 0, 0))).isFalse();
    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(10, 1, 6, 3)), TimeValue.of(0, 0, 0))).isFalse();
    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2007, 12, 3), TimeValue.of(9, 1, 6, 3)), TimeValue.of(0, 0, 0))).isFalse();
    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2007, 2, 23), TimeValue.of(9, 1, 6, 3)), TimeValue.of(0, 0, 0))).isFalse();
    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2008, 12, 23), TimeValue.of(9, 1, 6, 3)), TimeValue.of(0, 0, 0))).isFalse();

    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(9, 1, 6, 2)), TimeValue.of(9, 1, 6, 2))).isTrue();
    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(9, 1, 5, 3)), TimeValue.of(9, 1, 5, 3))).isTrue();
    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(9, 2, 6, 3)), TimeValue.of(9, 2, 6, 3))).isTrue();
    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(10, 1, 6, 3)), TimeValue.of(10, 1, 6, 3))).isTrue();
    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2007, 12, 3), TimeValue.of(9, 1, 6, 3)), TimeValue.of(20 * 24, 0))).isTrue();
    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2007, 2, 23), TimeValue.of(9, 1, 6, 3)), TimeValue.of(0, 10, 0))).isFalse();
    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2008, 12, 23), TimeValue.of(9, 1, 6, 3)), TimeValue.of(1, 0, 1))).isFalse();
  }

  /**
   * This method tests the {@code areClose} method for {@code DateTimeValue}s.
   */
  @Test
  public void test_are_close_for_timestamps_with_datetime() throws Exception {
    assertThat(
            Values.areClose(getValue(null, Timestamp.valueOf("2007-12-23 09:01:06.000000003")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(9, 1, 6, 3)),
                            DateTimeValue.of(DateValue.of(0, 0, 0)))).isTrue();
    assertThat(
            Values.areClose(getValue(null, Timestamp.valueOf("2007-12-23 09:01:06.000000003")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(9, 1, 5, 3)), DateTimeValue.of(DateValue.of(0, 0, 0)))).isFalse();
    assertThat(Values.areClose(getValue(null, ""),
                               DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(9, 1, 6, 3)), DateTimeValue.of(DateValue.of(0, 0, 0))))
            .isFalse();
    assertThat(Values.areClose(getValue(null, Timestamp.valueOf("2007-12-23 09:01:06.000000003")), (DateTimeValue) null, DateTimeValue.of(DateValue.of(0, 0, 0))))
            .isFalse();

    assertThat(
            Values.areClose(getValue(null, Timestamp.valueOf("2007-12-23 09:01:06.000000003")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(9, 1, 6, 2)), DateTimeValue.of(DateValue.of(0, 0, 0)))).isFalse();
    assertThat(
            Values.areClose(getValue(null, Timestamp.valueOf("2007-12-23 09:01:06.000000003")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(9, 1, 5, 3)), DateTimeValue.of(DateValue.of(0, 0, 0)))).isFalse();
    assertThat(
            Values.areClose(getValue(null, Timestamp.valueOf("2007-12-23 09:01:06.000000003")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(9, 2, 6, 3)), DateTimeValue.of(DateValue.of(0, 0, 0)))).isFalse();
    assertThat(
            Values.areClose(getValue(null, Timestamp.valueOf("2007-12-23 09:01:06.000000003")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(10, 1, 6, 3)), DateTimeValue.of(DateValue.of(0, 0, 0)))).isFalse();
    assertThat(
            Values.areClose(getValue(null, Timestamp.valueOf("2007-12-23 09:01:06.000000003")),
                            DateTimeValue.of(DateValue.of(2007, 12, 3), TimeValue.of(9, 1, 6, 3)), DateTimeValue.of(DateValue.of(0, 0, 0)))).isFalse();
    assertThat(
            Values.areClose(getValue(null, Timestamp.valueOf("2007-12-23 09:01:06.000000003")),
                            DateTimeValue.of(DateValue.of(2007, 2, 23), TimeValue.of(9, 1, 6, 3)), DateTimeValue.of(DateValue.of(0, 0, 0)))).isFalse();
    assertThat(
            Values.areClose(getValue(null, Timestamp.valueOf("2007-12-23 09:01:06.000000003")),
                            DateTimeValue.of(DateValue.of(2008, 12, 23), TimeValue.of(9, 1, 6, 3)), DateTimeValue.of(DateValue.of(0, 0, 0)))).isFalse();

    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23)), DateTimeValue.of(DateValue.of(0, 0, 0)))).isTrue();
    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(9, 1, 5, 3)), DateTimeValue.of(DateValue.of(0, 0, 0)))).isFalse();
    assertThat(Values.areClose(getValue(null, ""),
                               DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(9, 1, 6, 3)), DateTimeValue.of(DateValue.of(0, 0, 0)))).isFalse();
    assertThat(Values.areClose(getValue(null, Date.valueOf("2007-12-23")), (DateTimeValue) null, DateTimeValue.of(DateValue.of(0, 0, 0)))).isFalse();

    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(9, 1, 6, 2)), DateTimeValue.of(DateValue.of(0, 0, 0)))).isFalse();
    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(9, 1, 5, 3)), DateTimeValue.of(DateValue.of(0, 0, 0)))).isFalse();
    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(9, 2, 6, 3)), DateTimeValue.of(DateValue.of(0, 0, 0)))).isFalse();
    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(10, 1, 6, 3)), DateTimeValue.of(DateValue.of(0, 0, 0)))).isFalse();
    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2007, 12, 3), TimeValue.of(9, 1, 6, 3)), DateTimeValue.of(DateValue.of(0, 0, 0)))).isFalse();
    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2007, 2, 23), TimeValue.of(9, 1, 6, 3)), DateTimeValue.of(DateValue.of(0, 0, 0)))).isFalse();
    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2008, 12, 23), TimeValue.of(9, 1, 6, 3)), DateTimeValue.of(DateValue.of(0, 0, 0)))).isFalse();

    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(9, 1, 6, 2)), DateTimeValue.of(DateValue.of(0, 0, 1)))).isTrue();
    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(9, 1, 5, 3)), DateTimeValue.of(DateValue.of(0, 0, 1)))).isTrue();
    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(9, 2, 6, 3)), DateTimeValue.of(DateValue.of(0, 0, 1)))).isTrue();
    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2007, 12, 23), TimeValue.of(10, 1, 6, 3)), DateTimeValue.of(DateValue.of(0, 0, 1)))).isTrue();
    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2007, 12, 3), TimeValue.of(9, 1, 6, 3)), DateTimeValue.of(DateValue.of(0, 0, 20)))).isTrue();
    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2007, 2, 23), TimeValue.of(9, 1, 6, 3)), DateTimeValue.of(DateValue.of(0, 10, 0)))).isTrue();
    assertThat(
            Values.areClose(getValue(null, Date.valueOf("2007-12-23")),
                            DateTimeValue.of(DateValue.of(2008, 12, 23), TimeValue.of(9, 1, 6, 3)), DateTimeValue.of(DateValue.of(1, 0, 0), TimeValue.of(9, 1, 6, 3)))).isTrue();
  }
}