I would say go by your mood. I don't really distinguish scents by night or day that much in the winter. In the summer, sometimes the 'night' scents, which are generally heavier or thicker, would seem too much. However, I do wear 'night' time heavy oriental scents during the day in the summer, but just spray lightly. In the winter, when it is colder, I can wear anything, anytime.
However, some fragrances have an extra sophistication to them where it seems out of place during the day. Some just have that extra classiness that seems too good to wear during the day for just simple errands.