How long wine, beer and spirits last once opened

We all know that wine can taste a bit vinegary after a few days of being opened, but according to an alcohol expert, there are specific times you should adhere to