Below is the top query that very useful for daily use :
TO_LOCALTIME(TO_TIMESTAMP(EXTRACT_PREFIX(EXTRACT_SUFFIX([#Fields: date-time], 0, 'T'), 0, '.'), 'yyyy-MM-dd hh:mm:ss'))
SELECT event-id,COUNT(*) as count FROM '[LOGFILEPATH]' where TO_LOCALTIME(TO_TIMESTAMP(TO_STRING(EXTRACT_PREFIX([#Fields: date-time],0,'.')), 'yyyy-MM-ddThh:mm:ss')) between timestamp('2014/11/17 09:00:00', 'yyyy/MM/dd hh:mm:ss') and timestamp('2014/11/17 10:00:00', 'yyyy/MM/dd hh:mm:ss') and server-hostname like 'SGISGEX02' group by event-id