"I wouldn't want to be the bus, train or ferry drivers who more often than not have to deal with some pretty out-of-it people," the mayor said.
There were some areas of the central business district, such as Karangahape Rd, where problems remained, he said.
However he told the Herald the death had to be viewed in the context of an overall decrease in crime. Progress was being made through a combination of things, including having a mobile accident and emergency unit operating, better queue control and sharing of CCTV cameras.
But sometimes it wasn't enough.
Auckland city police prevention manager Inspector Gary Davey said: "From the police perspective it's quite clear that the 24-hour drinking regime isn't working and that the community seems to be suffering harm as a result."
He said the assaults would continue if the hours of drinking in the central city weren't reduced.
Next month, new legislation comes into effect stopping bars from opening beyond 4am, but the local alcohol policy provided an opportunity to either reduce or extend those hours.
"Police believe the whole object of the act is to reduce harm and encourage responsible drinking. That's why we want to see a harm minimisation approach and close the bars at 3am.
"What happens is the intoxication levels of people increases as the night wears on so the people who are left in town at 3, 4 and 5am are heavily intoxicated and [chances are] they become an offender or a victim," Mr Davey said.
- additional reporting: Heather McCracken
One punch
June 2011: Auckland man Trevor Kaukau received serious brain injuries when he was hit once, fell backwards and struck his head on Karangahape Rd.
August 2011: Hutt Valley man Felipo Sipaia died after he was punched in the head during a confrontation. He fell, hit his head and never regained consciousness.
October 2011: Billy Dawson, 34, died in hospital from severe head injuries after being punched once in the face outside a bar in Auckland's Viaduct Harbour. Kit Murray was later sentenced to five years' jail for manslaughter.