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

  → /sun/TrafficCount/trunk/sql/report.sql @ 40

  → /sun/TrafficCount/trunk/sql/report.sql @ 41

  ↔ Reverse comparison

• Compare Path:	Rev

  With Path:	Rev

No changes between revisions

Ignore whitespace Rev 40 → Rev 41

/sun/TrafficCount/trunk/sql/report.sql
0,0 → 1,19
select host, source, round((base + delta) / 1024 / 1024) as count, stamp from tcount
where source = 'tun0_out'
and stamp in (
(
select min(stamp) from tcount
where source = 'tun0_out'
and extract(month from stamp) = 8
and extract(year from stamp) = 2003
group by extract(day from stamp)
)
union
(
select min(stamp) from tcount
where source = 'tun0_out'
and extract(month from stamp) = 9
and extract(year from stamp) = 2003
)
)
order by stamp
Property changes:
Added: svn:keywords
+LastChangedDate LastChangedRevision LastChangedBy HeadURL Id
\ No newline at end of property