To be under the weather means to feel unwell.
To be over the moon means to be extremely happy or delighted.