Re: [SQL] Group by minute

2006-09-22 Thread Scott Marlowe
On Fri, 2006-09-22 at 10:52 -0300, Ezequias Rodrigues da Rocha wrote: > Hil list, > > I have a query but my IDE (Delphi) does not accept "to_char" > capability. Is there a way to reproduce the same query without using > to_char function ? > > Here is my query: > SELECT to_char(quando,'dd/MM/

Re: [SQL] Group by minute

2006-09-22 Thread Mezei Zoltán
Ezequias Rodrigues da Rocha wrote: Hil list, I have a query but my IDE (Delphi) does not accept "to_char" capability. Is there a way to reproduce the same query without using to_char function ? Here is my query: SELECT  to_char(quando,'dd/MM/ HH24:MI'),count(id) FROM base.tentativa

Re: [SQL] Group by minute

2006-09-22 Thread Niklas Johansson
On 22 sep 2006, at 15.52, Ezequias Rodrigues da Rocha wrote: I have a query but my IDE (Delphi) does not accept "to_char" capability. Is there a way to reproduce the same query without using to_char function ? ... GROUP BY to_char(quando,'dd/MM/ HH24:MI') To group by minute, you can t

[SQL] Group by minute

2006-09-22 Thread Ezequias Rodrigues da Rocha
Hil list,I have a query but my IDE (Delphi) does not accept "to_char" capability. Is there a way to reproduce the same query without using to_char function ?Here is my query:SELECT  to_char(quando,'dd/MM/ HH24:MI'),count(id) FROM base.tentativaWHERE  (SESSAO_ID = 15) GROUP BY to_char(quando,'dd