Contrary to the experiences of many others, I've never caught anything worthwhile at night. I've fished good places like Mohaka and Whakaki until 3am and caught nothing but sharks and stingrays.
Late afternoon 4-7pm or just after sunrise have been the most productive times for me regardless of location or tide position.