Personally, I have always had poor to bad fishing when fishing the day or night of a full moon. But, I have heard for some species, full moon is better. Now I'm confused. . .

A couple of links I found online regarding the subject:

http://www.primetimes2.com/pages/6-article.html
http://www.fishinfo.com/moon.htm