import java.sql.*; import java.util.*; import java.text.*; public class bug54095 { public static void main(String args[]) throws Exception { Calendar newYear=Calendar.getInstance(); SimpleDateFormat format=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); newYear.setTime(format.parse("2010-01-01 00:00:00")); System.out.println("newYear="+newYear.getTime()); Connection c=DriverManager.getConnection("jdbc:mysql://localhost/test?user=root&password=root&serverTimezone=UTC&useLegacyDatetimeCode=false&autoReconnect=true"); PreparedStatement s=c.prepareStatement("select * from atime where atimestamp>?"); s.setTimestamp(1,new Timestamp(0),newYear); s.close(); System.out.println("newYear="+newYear.getTime()); } }