Only when you wake up in the morning and are getting out of bed for the day.

If you wake up in the middle of the night and get out of bed you don't have to turn off sleep mode as the watch will automatically account for this.