java里的什么数据类型可以传到SQLServer数据库里进行时间比较?
PreparedStatement ps=conn.prepareStatement("select * from tableA where CONSUMEDATE>?");
ps.setTimestamp(1,startDate);
ps.executeQuery();
DATE和TIMESTAMP都不行,提示:
The specified date cannot be represented by a SQL Server datetime
有人知道怎么解决吗?