I think it perhaps it used to be more common but the supply of it is more controlled these days (due to misuse )

I have heard of doctors prescribing sedatives for short term use, to regain some kind of sleeping pattern in small children. But that's not misuse, it's a different thing altogether.

I'd be wary of giving it if it's not needed as I would be with any medication.