Hi Friends,

Can any one help me in calculating past N hrs,past week,past7days,pastNdays,past2weeks,past14days,this month. Date should be compare with today and should automatically calculate the selected date.

Thanks,

Shobana

Hi,

Any one help me to insert datas into mysql.

Thanks,

Shobana

Hi,

Any online to help me in fetching the data's quickly. if i run the query below its taking such a long time due to huge data's(1k) in each tables....

Can any one help to get quick results while running query in PostgreSQL?

when i run my query its taking such a long time due to huge data's in db.

Thanks,

Shobana

what is highlight?

Thanks,

Shobana

ERROR: syntax error at or near "highlight".

LINE 12: ...character varying)where (cast(am.itime as

This is the error i am getting

Thanks

shobana

Is it possible to use webserver and get connected to DB to get quick results

Thanks,

Shobana

yup

Thanks a lot for your help

Replacement every thing over. Now if i run the below query its querying for long time due to huge datas in DB(PostgreSQL). if i run...

exactly.

if the user wants the reports for 1hr...

this query has to generate 1hr report..

Thanks,

Shobana

select distinct split_part(split_part(cp.msg, 'src=',1),',',1),split_part(split_part(cp.msg, 'user=''',2),',',1) as user ,am.itime,am.dtime,am.url from "FGT60B3908669009-wlog-1380091698" am join "SYSLOG-C0A80A41-glog-1380347892" cp on cast(am.src as character varying)=cast((split_part(split_part(cp.msg, 'src=',2),',',1) ) as character varying) where am.src='192.168.10.23' and replace('$filter', 'itime',...

we go with condition 1..

Thanks

Shobana

ERROR: argument of AND must be type boolean, not type text.

LINE 1: ...aracter varying) where am.src='192.168.10.23' and replace('i... ...

With the help of my query can you add your CASE command and show me the query?

Thanks

Shobana

what this command will do?

whether it gives report for n timestamp(say 1h,one day like that)?

Thanks

Shobana