@Test
public void testLoadFromStoreTo() {
Calendar c = Calendar.getInstance();
c.set(2001, 0, 1, 2, 3, 4);
c.set(Calendar.MILLISECOND, 500);
JDateTime jdt = Convert.toJDateTime(c);
assertEquals("2001-01-01 02:03:04.500", jdt.toString());
Calendar c1 = Convert.toCalendar(jdt);
assertEquals(2001, c1.get(Calendar.YEAR));
assertEquals(0, c1.get(Calendar.MONTH));
assertEquals(1, c1.get(Calendar.DAY_OF_MONTH));
assertEquals(2, c1.get(Calendar.HOUR_OF_DAY));
assertEquals(3, c1.get(Calendar.MINUTE));
assertEquals(4, c1.get(Calendar.SECOND));
assertEquals(500, c1.get(Calendar.MILLISECOND));
GregorianCalendar gc = new GregorianCalendar(2002, 5, 2, 3, 4, 5);
gc.set(GregorianCalendar.MILLISECOND, 600);
jdt = Convert.toJDateTime(gc);
assertEquals("2002-06-02 03:04:05.600", jdt.toString());
GregorianCalendar gc1 = (GregorianCalendar) Convert.toCalendar(jdt);
assertEquals(2002, gc1.get(GregorianCalendar.YEAR));
assertEquals(5, gc1.get(GregorianCalendar.MONTH));
assertEquals(2, gc1.get(GregorianCalendar.DAY_OF_MONTH));
assertEquals(3, gc1.get(GregorianCalendar.HOUR_OF_DAY));
assertEquals(4, gc1.get(GregorianCalendar.MINUTE));
assertEquals(5, gc1.get(GregorianCalendar.SECOND));
assertEquals(600, gc1.get(GregorianCalendar.MILLISECOND));
Date d = new Date(101, 2, 3, 4, 5, 6);
jdt = Convert.toJDateTime(d);
assertEquals("2001-03-03 04:05:06.000", jdt.toString());
Date d2 = Convert.toDate(jdt);
assertEquals(101, d2.getYear());
assertEquals(2, d2.getMonth());
assertEquals(3, d2.getDate());
assertEquals(4, d2.getHours());
assertEquals(5, d2.getMinutes());
assertEquals(6, d2.getSeconds());
JDateTime gt_new = new JDateTime(2003, 6, 5, 4, 3, 2, 100);
jdt.setJulianDate(gt_new.getJulianDate());
assertEquals("2003-06-05 04:03:02.100", jdt.toString());
JDateTime gt2 = jdt.clone();
assertEquals(2003, gt2.getYear());
assertEquals(6, gt2.getMonth());
assertEquals(5, gt2.getDay());
assertEquals(4, gt2.getHour());
assertEquals(3, gt2.getMinute());
assertEquals(2, (int) gt2.getSecond());
assertEquals(100, gt2.getMillisecond());
java.sql.Date sd = new java.sql.Date(123, 4, 5);
jdt = Convert.toJDateTime(sd);
assertEquals("2023-05-05 00:00:00.000", jdt.toString());