Well, it depends.
DMT is a pretty intense substance and the experience could very well leave you with a lot of stuff to think about, which could make it difficult to sleep.
There shouldn´t be any psychical stimulation afterwards causing a restless night though.
I never had any problem sleeping afterwards but I havent smoked it that late really, like 5 pm and go to sleep at 11 pm - no problem.