When do you tell someone sweet dreams?

The term, "Sweet Dreams" is used when somebody is going to bed. You are telling them to have good dreams while they sleep. This is usually said to someone close or related to the speaker.