//按天统计
select count(dataid) as 每天操作数量, sum()
from
where
group by trunc(createtime, "DD"))
//按自然周统计
select to_char(date,"iw"),sum()
from
where
group by to_char(d
脚本之家
var t = null;
function time(){
dt = new Date();
var y=dt.getFullYear();
var h=dt.getHours();
var m=dt.getMinutes();
var s=dt.getSeconds();
document.getElementById("timeShow
--创建表 Test
CTEATE TABLE TEST(
ID NUMBER NOT NULL,
MODIFIEDTIME DATE NOT NULL
)
--按周统计
SELECT TO_CHAR(T.MODIFIEDTIME,"YYYY") YEAR,TO_CHAR(T.MODIFIEDTIME,"IW") TIME,COUNT(*
