It was about 7 hours long: https://en.wikipedia.org/wiki/Northeast_blackout_of_2003. Where I lived it was restored very quickly.

I had a long blackout as a kid during a hurricane in 1985. Once it was safe it was repaired rather quickly.