sql function sqlserver postgres oracle - ghdrako/doc_snipets GitHub Wiki
tags:
- sql
Sql function sqlserver postgres oracle
| Funkcja | SQL Server | Oracle | Postgres |
|---|---|---|---|
| SUBSTRING | SUBSTRING('ABCD', 2, 2) → 'BC' | SUBSTR('ABCD', 2, 2) → 'BC' | SUBSTRING('ABCD', 2, 2) → 'BC' |
| LENGTH | LEN('ABCD') → 4 | LENGTH('ABCD') → 4 | LENGTH('ABCD') → 4 |
| Aktualna data | GETDATE() | SYSDATE | NOW() lub CURRENT_TIMESTAMP |
| Dodawanie dni | DATEADD(DAY, 5, GETDATE()) | SYSDATE + 5 | NOW() + INTERVAL '5 DAY' |
| Różnica między datami | DATEDIFF(DAY, '2023-01-01', '2023-01-10') → 9 | (TO_DATE('2023-01-10') - TO_DATE('2023-01-01')) → 9 | DATE_PART('day', '2023-01-10'::timestamp - '2023-01-01'::timestamp) → 9 |
| Formatowanie daty | FORMAT(GETDATE(), 'yyyy-MM-dd') |
TO_CHAR(SYSDATE, 'YYYY-MM-DD') |
TO_CHAR(NOW(), 'YYYY-MM-DD') |
| GROUP_CONCAT | STRING_AGG(column, ',') |
LISTAGG(column, ',') |
STRING_AGG(column, ',') |
| Generowanie GUID | NEWID() |
SYS_GUID() |
gen_random_uuid() (wymaga rozszerzenia pgcrypto) |
| Kopia tabeli | CTAS | CTAS | SELECT * INTO NewTable FROM ExistingTable WHERE Condition; |