Question

Access数据库 怎样写取得当前时间前6小时的数据

表里有三个字段 date 是日期(格式是2009-12-11)hour是小时 seconds是分钟请教完整SQL 查询语句

Answer 1

SQL:
SELECT *
FROM TIME
WHERE day=#2009-12-11# AND Datediff('h',hour,#22:00:00#)<6

JAVA:
StringBuffer strSQL =new StringBuffer();
SimpleDateFormat sdFormatDay = new SimpleDateFormat("yyyy-MM-dd");
SimpleDateFormat sdFormatHour = new SimpleDateFormat("HH");

long currentTime=System.currentTimeMillis();
String strDay = new String(sdFormatDay.format(currentTime));
String strHour = new String(sdFormatHour.format(currentTime));

System.out.println("日期 : " + strDay);
System.out.println("小时 : " + strHour);

strSQL.append("SELECT * FROM TIME WHERE day=#");
strSQL.append(strDay);
strSQL.append("# AND Datediff('h',#");
strSQL.append(strHour);

Answer 2

Where datediff('h',日期,Now)