HF RL Explorer

Task: Calculate Difference Between Two Dates in SQLite

Task: Calculate Difference Between Two Dates in SQLite: a task in Terminal-Lego-15k (Harbor dataset). Create a SQLite database and write a query that correctly calculates the difference in days between two dates. The naive approach of subtracting dates directly (e.g., Date('now') - DateCreated )…

The task

Create a SQLite database and write a query that correctly calculates the difference in days between two dates. The naive approach of subtracting dates directly (e.g., `Date('now') - DateCreated`) returns 0 in SQLite because SQLite does not support direct date arithmetic with the `-` operator on date strings. You must…

Part of PrimeIntellect/Terminal-Lego-15k.