Loading interview...

The Timezone Trap

A medium Python mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.

Domain
Python
Difficulty
medium
Seniority
mid, senior

Interview Prompt

All trip timestamps in our ride database are stored in UTC, but the San Francisco ops team keeps asking for monthly counts in local time. A trip completed at midnight UTC on January 1st is still December 31st in California. Given the trip records, count completed SF trips per month using Pacific time.

How This Interview Works

  1. Read the vague prompt (just like a real interview)
  2. Ask clarifying questions to the AI interviewer
  3. Write your python solution with real code execution
  4. Get instant feedback and a hire/no-hire decision