If you mean it was shot in a night shot mode (and is green rather than normal colour), I don't think there is much you can do. You've lost most of the colour information, so even using an editor with good colour correction tools, you won't be able to get that colour back. I use Sony Vegas and it has good colour correction tools, but even with that it would be difficult and the colour may not be very good. See this thread from the Vegas forum; converting it to black and white seems the most popular option.
Edit: Sorry forgot the link
http://www.sonymediasoftware.com/for...ssageID=443824
Mark