除了从今天开始，选择所有行?

I'm selecting all rows except those from last 24hs. Instead I'd like to select those which are not from today. I'm already getting the day from a datetime column using DATE().I'm selecting all rows except those from last 2