BlueGreycalmElegant

Català-Valencià – Catalan中文 – Chinese (Simplified)中文 – Chinese (Traditional)Česky – CzechDansk – DanishNederlands – DutchEnglish – EnglishSuomi – FinnishFrançais – FrenchDeutsch – Germanעברית – Hebrewहिंदी – HindiMagyar – HungarianBahasa Indonesia – IndonesianItaliano – Italian日本語 – Japanese한국어 – KoreanМакедонски – Macedonianमराठी – MarathiNorsk – NorwegianPolski – PolishPortuguês – PortuguesePortuguês – Portuguese (Brazil)Русский – RussianSlovenčina – SlovakSlovenščina – SlovenianEspañol – SpanishSvenska – SwedishTürkçe – TurkishУкраїнська – UkrainianOëzbekcha – Uzbek

Compare Revisions

• This comparison shows the changes necessary to convert path

  → /TrafficCount/trunk/sql/report_per_day.sql @ 964

  → /TrafficCount/trunk/sql/report_per_day.sql @ 965

  ↔ Reverse comparison

• Compare Path:	Rev

  With Path:	Rev

Ignore whitespace Rev 964 → Rev 965

/TrafficCount/trunk/sql/report_per_day.sql
0,0 → 1,27
select (date (day || ' Sep 2003')) as the_date,
round((
(
select base + delta from tcount
where source = 'tun0_in'
and stamp = (
select max(stamp) from tcount
where date_trunc('day', stamp) = date (day || ' Sep 2003')
and source = 'tun0_in'
)
)
-
(
select base + delta from tcount
where source = 'tun0_in'
and stamp = (
select max(stamp) from tcount
where date_trunc('day', stamp) = date (day || ' Sep 2003') - interval '1 day'
and source = 'tun0_in'
)
)
) / 1024 / 1024)
as count
from tdays d
where day <= 30
order by the_date;