This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.

I'll push a change that casts the two dates (in your case probably timestamps) as dates before subtracting instead. It seems you have observation_period_start_date and observation_period_end_date ...

Day 25 of 90 (days of SQL) Different SQL dialects (SQL Server, PostgreSQL, MySQL, Oracle) have slightly different syntax, but the concepts are the same. 🔹 1. DATEDIFF Finds the difference between two ...

🚨 PostgreSQL tip for anyone coming from SQL Server Ever tried this in Postgres? 👇 DATEDIFF (month, start_date, end_date) …and got stuck 😤 👉 PostgreSQL doesn’t support DATEDIFF (). But you do have ...