The resignation of Chuck Rosenberg takes effect on 1 October, two months after he repudiated President Trumps controversial advice to law enforcement officers on Long Island.