Sayyiduna Anas (may Allah be pleased with him) said that a man who had become intoxicated was brought to the Prophet (peace and blessings be upon him). He (peace and blessings be upon him) ordered about 20 men: "Beat him with sandals and palm stalks."
In this hadith there is the possibility that he was brought after his intoxication had worn off.
Hadith Referenceالسنن الكبرى للبيهقي / كتاب الأشربة والحد فيها / 17522