When an individual finds difficulty in going to sleep on Sunday night because they know they have to get up for work or school the following morning. This may also apply on any holiday night before a working day.
Guy 1: How did you sleep last night? You look tired.
Guy 2: I am, I think I had a case of Sunday Night Syndrome.
Guy 1: Ah that always happens to me, it's really annoying.