Pissed as a (brewer’s) fart
According to the OED, this rather crude simile for being drunk dates from the 1990s. According to Cassells Dictionary of Slang it dates from the 1960s.