SqlDateTest.java

package ca.fuerth.misc;

import static org.junit.Assert.*;

import java.sql.Date;
import java.text.DateFormat;
import java.util.TimeZone;

import org.junit.Test;


public class SqlDateTest {

    @Test
    public void testCreatedWithMillis() {
        Date sqldate = new Date( 86400 * 1000 );

        DateFormat df = DateFormat.getDateTimeInstance();
        df.setTimeZone( TimeZone.getTimeZone( "GMT" ) );
        System.out.println("Created with millis: " + df.format(sqldate));

        assertEquals(86400 * 1000, sqldate.getTime());
        assertEquals( 70, sqldate.getYear() );
        assertEquals( 0, sqldate.getMonth() );
        assertEquals( 2, sqldate.getDate() );
    }

    @Test
    public void testCreatedWithYearMonthDay() {
        Date sqldate = new Date(70, 0, 2);

        DateFormat df = DateFormat.getDateTimeInstance();
        df.setTimeZone( TimeZone.getTimeZone( "GMT" ) );
        System.out.println("Created with YMD: " + df.format(sqldate));

        assertEquals( 70, sqldate.getYear() );
        assertEquals( 0, sqldate.getMonth() );
        assertEquals( 2, sqldate.getDate() );
        assertEquals("Timestamp wasn't exactly 24 hours from the epoch: " + sqldate.getTime() / (86400.0 * 1000) + " days",
                86400 * 1000, sqldate.getTime());
    }

}