I could do it i After Effects just send me the footage and Gimme some credit at the Credits

Thanks capedkid. but I'm more wondering how I would set it up more than doing it in After effects.  I don't use after effects so is there a way to do it in GIMP or Sony Vegas?

I understand. I'm just wondering if there is a specific setup for this kind of shot.

Sunset would involve placing the lamps lower down to simulate the sun being lower in the sky and covering them with orange gels, though twiddling with the white balance might be able to deliver the same effect.

Night-time shots involve lighting the set reasonably well and then turning down the exposure on your camera.