Adjust screen brightness automatically at night
One app to try
f.lux™ Better lighting...for your computer
it makes the color of your computer's display adapt to the time of day, warm at night and like sunlight during the day.
Available for XP/Vista/7, OSX and linux
None of the currently suggested solutions actually change the brightness of the monitor automatically at night. Especially if you are on a desktop setup changing the brightness of each of your monitors is a pain.
This utility from Nirsoft allows you to change monitor variables from the command line. By creating a tasks in Windows' Task Scheduler to run at a certain times you could set your monitors brightness to progressively lower values.
However that solution is not completely seamless. If you're OK with using freeware to solve this issue, ClickMoniterDDC is a GUI that can change the brightness of monitors at certain times and far more.
You can use Dimmer for Windows to lower the brightness itself between 5% and 95% opacity.
f.lux is great, but it just doesn't do enough; you can use it in combination with Dimmer, though.