select generic_create_time from security_log where generic_create_time BETWEEN addWeeks(now64(), -1) and now64()