PostgreSQL → SQL Server

Date Difference in Days: PostgreSQL to SQL Server Translation

date1 - date2 in PostgreSQL returns days. In SQL Server use DATEDIFF(day, date2, date1).

In PostgreSQL, subtracting two date or timestamp values returns an interval or integer days depending on types. In SQL Server, direct datetime subtraction is not portable — use DATEDIFF.

Translation

PostgreSQL

SELECT (end_date::date - start_date::date) AS days FROM periods;

SQL Server

SELECT DATEDIFF(day, start_date, end_date) AS days FROM periods;

Analisador de Impacto

Reports with date arithmetic are a classic reverse-migration trap. Analyze the entire project at once.

Abrir Análise de Projeto →