An Offaly-born off-duty NYPD detective has been released from hospital in New York after being struck in the head by a man with a 28cm cleaver.