SQL Converter · PostgreSQL → T-SQL

Convert PostgreSQL SQL to T-SQL

PostgreSQL to SQL Server swaps LIMIT for TOP, "double quotes" for [brackets], ILIKE for LIKE and now() for GETDATE(). A mechanical formatter only re-indents — it won’t rewrite dialect-specific syntax. The AI converter in the app translates the query and the table below shows exactly what changes.

PostgreSQL — source

PostgreSQL

SELECT p.id, p.title
FROM posts p
WHERE p.title ILIKE '%sql%'
  AND p.published_at > now() - INTERVAL '1 month'
ORDER BY p.published_at DESC
LIMIT 50;

T-SQL — converted

T-SQL

SELECT TOP 50 p.id, p.title
FROM posts p
WHERE p.title LIKE '%sql%'
  AND p.published_at > DATEADD(MONTH, -1, GETDATE())
ORDER BY p.published_at DESC;

Convert your own query

What changes from PostgreSQL to T-SQL

PostgreSQL	T-SQL	Why
LIMIT 50	SELECT TOP 50	Postgres LIMIT becomes a leading TOP clause.
ILIKE	LIKE	T-SQL LIKE is case-insensitive by collation; there is no ILIKE.
now() - INTERVAL '1 month'	DATEADD(MONTH, -1, GETDATE())	Interval math becomes DATEADD.

Other SQL conversions

PostgreSQL → MySQL MySQL → T-SQL PostgreSQL → Redshift PostgreSQL → BigQuery PostgreSQL → Snowflake All conversions →