The story
From the story of Cinderella, in which a pumpkin magically transformed into a coach reverts to its original form at midnight.
Etymology from Wiktionary, CC BY-SA 4.0.
turn into a pumpkin
Today it means: To go to bed; to go to sleep (especially at, or around midnight). Full definition →