The general idea is to be congruent with the environment and situation you're in. If you work in an office where everyone is pretty conservatively dressed (e.g ties, jackets and ties, suits) you wouldn't show up with sneakers, jeans and a wild coloured shirt too often, nor would you show up dressed for hitting a night spot. If it's a cold night or the middle of winter, you wouldn't be wearing shorts and short sleeved shirt.
It's similar with scents. Strong orientals seem to be more appropriate at night, strong woody scents seem more appropriate in cooler weather or at night. Lighter, fresher scents seem to go better with day time use, when the weather is warmer or on hot nights (the idea being that they maintain a sense of freshness around you, which would otherwise have disappeared hours before). Citrus and aquatic scents seem much better worn in summer, and a bit odd in winter. And there are numerous well balanced scents that work in either situation. If you show up at the office wearing a scent which screams "I want to party" or "I'm on the hunt" - it doesn't seem right on a normal working day.
That said, there's plenty of room for experimentation, a heavy oriental applied lightly may go down well in day time use. A fresh oriental may go down well even if applied strongly. No one's going to come tell you off that you're wearing an inappropriate scent.
I've on occasion come across men conservatively dressed in dark suits, where my first thought was "that oriental he's wearing just doesn't match". My thoughts were that if he'd wanted to make a statement, there are plenty of better scents around to do it, or that maybe he's wearing the only scent he's got - which he got for Christmas or Father's day - and he doesn't know any better.
Anyhow, that's my perception.