import java.sql.Date;
import java.sql.Timestamp;
import java.time.LocalDate;
import java.time.LocalDateTime;

public class SqlDateTest {
    public static void main(String[] args) {
        LocalDate zero = LocalDate.of(0,4,4);
        LocalDate startDate = zero.minusYears(200);
        Date sqlDate = Date.valueOf(startDate);
        LocalDate dateFromDatabase = sqlDate.toLocalDate();
        LocalDateTime startStamp = LocalDateTime.of(-200,4,4,10,30,0);
        Timestamp sqlStamp = Timestamp.valueOf(startStamp);
        LocalDateTime stampFromDatabase = sqlStamp.toLocalDateTime();
        System.out.println("Date sent to database: " + startDate);
        System.out.println("Date returned from database: " + dateFromDatabase);
        System.out.println("Timestamp sent to database: " + startStamp);
        System.out.println("Timestamp returned from database: " + stampFromDatabase);
    }
} 