@Test
public void testConvertToSqlDate01() {

    // setup test data
    DateTime date = new DateTime(2012, 9, 3, 23, 7, 11, 100);
    // testing
    java.sql.Date sqlDate = DateConvertUtils.convertToSqlDate(date
            .toDate());
    // assertion
    DateTime result = new DateTime(sqlDate.getTime());
    assertThat(result.getYear(), is(2012));
    assertThat(result.getMonthOfYear(), is(9));
    assertThat(result.getDayOfMonth(), is(3));
    assertThat(result.getHourOfDay(), is(0));
    assertThat(result.getMinuteOfHour(), is(0));
    assertThat(result.getSecondOfMinute(), is(0));
    assertThat(result.getMillisOfSecond(), is(0));
}