I agree...it's a wonderful drug. I had a colonoscopy, and my recent nose repair under it's influence and don't remember a thing.
In Australia we go by the brand name Hypnovel, but it's the same drug though (Midazolam).
But do as the others say....go home & rest. Best to reschedule your other appointment.
__________________
Eastern Australian Daylight Savings Time
and
my temperature
.