What is the preposition in by midnight you were all tired?

In the sentence "By midnight you were all tired," the preposition is "by." It indicates a point in time before which the action or state of being (in this case, being tired) occurs.