create table LOG_TIMESLICE (
RESPONSE_AVERAGE_TIME int8,
SEARCH_COUNT int8,
COLLECTION_NAME varchar(255),
REG_DATE datetime year to FRACTION
);
Table의 script는 다음과 같습니다.
하구 싶은 작업은 Oracle로 만든 예로는
select sum(search_count) as querysum, timeslice,
avg(RESPONSE_AVERAGE_TIME) as average
from (
select collection_name, search_count,
RESPONSE_AVERAGE_TIME, to_char(reg_date,'yyyymmddhh24') as
timeslice
rom M2_LOG_TIMESLICE where reg_date between sysdate-1
and sysdate
)temp
where collection_name = "news"
by timeslice
order by timeslice asc
와 같은 query를 Informix로 converting하면 됩니다.
SELECT collection_name, sum(search_count) as querysum,
RESPONSE_AVERAGE_TIME as average, to_char(reg_date, '%Y%m%d%H%M%S')
as timeslice
FROM M2_LOG_TIMESLICE WHERE
reg_date between (CURRENT MONTH TO HOUR - INTERVAL(24) UNITS
HOUR) AND CURRENT MONTH TO HOUR
where collection_name = "news"
BY timeslice, collection_name
ORDER BY timeslice asc;
이런식으로 변경하고 싶습니다.
현제부터 24시간 전까지의 row를 fetch해 오고 싶은데 informix에서
어떻게 하시는줄 아시는분이 있다면 답변을 부탁드리겠습니다.
|