Brilliant!
On Fri, Aug 1, 2008 at 12:18 PM, Steve Crawford
<[EMAIL PROTECTED]> wrote:
> Nathan Thatcher wrote:
>>
>> I have, what I imagine to be, a fairly simple question. I have a query
>> that produces output for a line graph. Each row represents an interval
>> on the graph.
>>
>> SELECT COUNT(
Nathan Thatcher escreveu:
I have, what I imagine to be, a fairly simple question. I have a query
that produces output for a line graph. Each row represents an interval
on the graph.
SELECT COUNT(call_id) AS value, EXTRACT(hour from start_time) AS hour
FROM c_call WHERE start_time >= '2008-08-01
Nathan Thatcher wrote:
I have, what I imagine to be, a fairly simple question. I have a query
that produces output for a line graph. Each row represents an interval
on the graph.
SELECT COUNT(call_id) AS value, EXTRACT(hour from start_time) AS hour
FROM c_call WHERE start_time >= '2008-08-01 00
