比如怎样选取日期在 99-01-01 到99-12-31之间的所有记录?
直接select * from table where date 字段 between 99-01-01 and 99-12-31不行,那么select * from table where date字段 between '99-01-01' and '99-12-31'也不行,就算你把日期先格式化datevalue()也不行。
其实简单点用下面这句就可以搞定了
select * from table where date字段 between # 99-01-01 # and #99-12-31#
也可以这样.
select * from table where date字段 < = # 99-01-01 # And date字段 >= #98-01-01#
时间相等
SELECT * from vstat where datediff('d',vtime,date())=0 (access)
select * from rep1data where datediff(day,riqi,'"&riqi&"')=0 (sqlserver)
javascript的
<head>
<script language="javascript">
function diffe(){
var olddata = new Date(2003,1,1);
var today = new Date();
var diff = today.getTime()-olddata.getTime();
diff = Math.floor(diff/(1000*60*60*24));
alert(diff);
}
</script>
</head>
<body">
<input type="submit" onClick=diffe()>
</body>