Zmiany pomiędzy wersją 30 and wersją 31 dla DeployerGuide/Custumization/AdvancedReporting/SQLExamples

Data i czas:

04/14/15 23:58:05 (9 years temu)

Autor:

JP (IP: 79.188.124.105)

Komentarz:

--

DeployerGuide/Custumization/AdvancedReporting/SQLExamples

@@ -18 +18 @@
 -- Zwraca kalendarz dni, nr tygodnia, miesiąć dla bieżącego roku
 -- przydatne do JOIN-owania z zapytaniami
-SELECT ndate, nday, to_char(ndate, 'D')::int - 1 AS dayweek, to_char(ndate, 'WW') AS week, to_char(ndate, 'MM') AS month FROM
+SELECT ndate, nday, 
+date_part('day', ndate)  || '(' || to_char(ndate, 'Dy') || ')' AS day,
+to_char(ndate, 'D')::int - 1 AS dayweek, to_char(ndate, 'WW') AS week, to_char(ndate, 'MM') AS month FROM
 (
 SELECT sr.sr AS nday, (date_trunc('year', now()) + (sr.sr || 'day')::interval)::date AS ndate
 FROM generate_series(0,365) AS sr
 ) AS calendar
+