All pastes #3044 Raw Edit

Connor

public sql v1 · immutable
#3044 ·published 2004-12-16 15:50 UTC
rendered paste body
SELECT  src,dst ,CASE billsec % 6  WHEN 0 THEN ((( (billsec/6) *6)::float(1)/60)::float(1))::float(1)  ELSE        ((( ((billsec/6 +1)* 6))::float(1)/60)::float(1))::float(1)END as minutes,accountcode,CASE accountcode  WHEN 'INTRA' THEN .035  ELSE .025END as RATE,CASE accountcode  WHEN 'INTRA' THEN    CASE billsec % 6      WHEN 0 THEN ((( (billsec/6) *6)::float(1)/60)::float(1)*.035)::float(1)      ELSE        ((( ((billsec/6 +1)* 6))::float(1)/60)::float(1)*.035)::float(1)    END ELSE     CASE billsec % 6      WHEN 0 THEN ((( (billsec/6) *6)::float(1)/60)::float(1)*.025)::float(1)      ELSE        ((( ((billsec/6 +1)* 6))::float(1)/60)::float(1)*.025)::float(1)    ENDEND as amountFROM "public".cdr WHERE calldate >= '11/01/2004' and calldate < '12/01/2004'and billsec > 0and (src like '843%')order by dst;