Thankfully the Giant lives in Philadelphia and not Queens anymore so he and Mrs. Giant probably escaped the worst of it.
I think it's gonna be longer. I'd say at least a week. There's at least 7 feet of flooding in several tunnels; it's going to take a long time to pump out.