No, you don't want to go to work or drive after taking it. It should be used only at night. Sorry you failed that drug test. It reminds me of Seinfeld when J Peterman thought Elaine was hooked on heroin because she always ate poppyseed muffins.
I still got the job. I told them I'd fail and had the prescription with me. Been there 15 years, so I guess they believed me.