Abu al-Zinad (may Allah have mercy on him) reports from the jurists of the people of Madinah that the prescribed punishment should not be applied to an intoxicated person before his intoxication wears off.
Hadith Referenceالسنن الكبرى للبيهقي / كتاب الأشربة والحد فيها / 17528