HF RL Explorer

Task: Find Difference Between Timestamps in Seconds in PostgreSQL

Task: Find Difference Between Timestamps in Seconds in PostgreSQL: a task in Terminal-Lego-15k (Harbor dataset). Write a SQL script that calculates the difference between two timestamp columns in seconds in PostgreSQL. The result should represent the total difference in seconds (including days…

The task

Write a SQL script that calculates the difference between two timestamp columns in seconds in PostgreSQL. The result should represent the **total** difference in seconds (including days, hours, and minutes converted to seconds), not just the seconds component of the interval.

Part of PrimeIntellect/Terminal-Lego-15k.