In short- no it doesn't.
Valium is an anti anxiety drug so when you take it you calm down and feel very comfortable- like being wrapped in a big cosy duvet.
Howver sleep is much easier on it because it's reduced your mind to a state of calm. You don't worry about anything so you're chilled out enough to drop off nice and easy.
I've used it many times after clubbing when i've felt too wired to sleep- 10mg of the stuff chills me right out and enables me to nod off.
I also take it when flying long haul- even if I don't want to sleep.
Not had any for months and months though