无标题文档
function relTime(clock){var now = new Date();var day = now.getDay();var year = now.getFullYear();var month = now.getMonth();var date = now.getDate();var hour = now.getHours()
--创建表 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(*
