I worked the night shift for awhile. I actually loved it, because my boss wasn't in then, so it was low-stress.
It didn't affect my mood very much. I was actually really stable the whole time. But I was on good meds, and had just finished getting some very effective therapy.