@Test
public void valueToString() throws Exception {

  Calendar dateTime = Calendar.getInstance();
  dateTime.clear();
  setTimeZone(dateTime, "GMT+11:30");
  dateTime.set(1, 2, 3, 4, 5, 6);
  assertEquals("04:05:06", instance.valueToString(dateTime, null, null, null, null, null));
  dateTime.add(Calendar.MILLISECOND, 42);
  assertEquals("04:05:06.042", instance.valueToString(dateTime, null, null, null, null, null));
  assertEquals("04:05:06.042", instance.valueToString(dateTime, null, null, 3, null, null));
  assertEquals("04:05:06.042", instance.valueToString(dateTime, null, null, 4, null, null));
  Calendar dateTime2 = Calendar.getInstance();
  dateTime2.clear();
  setTimeZone(dateTime, TimeZone.getDefault());
  dateTime2.set(Calendar.HOUR, 5);
  dateTime2.set(Calendar.MINUTE, 59);
  dateTime2.set(Calendar.SECOND, 23);
  final java.sql.Time time = new java.sql.Time(dateTime2.getTimeInMillis());
  assertEquals("05:59:23", instance.valueToString(time, null, null, null, null, null));
  assertEquals("05:59:23", instance.valueToString(dateTime2.getTimeInMillis(), null, null, null, null, null));
    Timestamp timestamp = new Timestamp(0);
    timestamp.setNanos(42);
  expectTypeErrorInValueToString(instance, 0);
}