在Java 1.7.0下运行的SQL-Server(MSSQL-JDBC 3.0)中的日期列检索为过去2天

import java.util.Date;
import java.util.Calendar;

Date today = new Date();
Calendar calendar = Calendar.getInstance();
calendar.setTime(today);
calendar.add(Calendar.DATE, -2);
Date twoDaysAgo = calendar.getTime();

import java.time.LocalDate;
import java.time.Period;

LocalDate today = LocalDate.now();
LocalDate twoDaysAgo = today.minus(Period.ofDays(2));

import java.sql.Date;

Date sqlDate = new Date(twoDaysAgo.getTime());

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

String sql = "SELECT * FROM your_table WHERE your_date_column >= ?";
PreparedStatement pstmt = connection.prepareStatement(sql);
pstmt.setDate(1, sqlDate);
ResultSet resultSet = pstmt.executeQuery();