Re: [Dbix-class] How would I...

2007-07-04 Thread Jess Robinson
On Tue, 3 Jul 2007, Len Jaffe wrote: On 7/3/07, Kevin Esteb [EMAIL PROTECTED] wrote: How would I format the following query? select to_char(datetime,'-MM-DD') as date,url,sum(number_requests) from request group by date,url order by date,url; I have tried several different

Re: [Dbix-class] How would I...

2007-07-03 Thread Len Jaffe
On 7/3/07, Kevin Esteb [EMAIL PROTECTED] wrote: How would I format the following query? select to_char(datetime,'-MM-DD') as date,url,sum(number_requests) from request group by date,url order by date,url; I have tried several different iterations, but the as date seems to trip me up.