Some say when you can't sleep you should take coffee, it will help you relax and you will fall asleep easy.
I think of it as the other effect. When someone is on graveyard shift or wants to remain awake at night, drinking coffee will make you remain awake.
But it depends on how strong the brew is with the coffee you intake. Maybe for some people, drinking one will make them fall asleep quickly.