SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
java.util.Date myDate=new java.util.Date();
long myTime=(myDate.getTime()/1000)-60*60*24*7;
myDate.setTime(myTime*1000);
String mDate=formatter.format(myDate);
java.util.Date myDate=new java.util.Date();
long myTime=(myDate.getTime()/1000)-60*60*24*7;
myDate.setTime(myTime*1000);
String mDate=formatter.format(myDate);
declare @time datetime
set @time='2005-07-07 15:30:00'select * from test where datediff(day,@time,getdate()-7)>=0--明白我的意思吗?
我写过
--变量@time假设为你表中记录的时间
declare @time datetime
set @time='2005-07-07 15:30:00'select * from test where datediff(day,@time,getdate()-7)>=0--明白我的意思吗?请问time是表示test表的的一个字段吗?试了好像不行,提示INT is Incompatible with datetime,能解释一下datadiff函数吗?楼主,不好意思,借用你的帖问问题,下不为例