if you come to long island, atlantis marine world is pretty nice. they have a big reef tank, but the rest of the aquarium isnt that big. its not a whole day thing, more like 4 or 5 hours.
you could also come see coney island aquarium if you visit the area, thats another good aquarium.
its best to visit both in the summer so you can see the out door exhibits.