Group by minute - Mailing list pgsql-sql

From Ezequias Rodrigues da Rocha
Subject Group by minute
Date
Msg-id 55c095e90609220652t356c8591u412046aed091a52f@mail.gmail.com
Whole thread Raw
Responses Re: Group by minute
Re: Group by minute
Re: Group by minute
List pgsql-sql
Hil list,<br /><br />I have a query but my IDE (Delphi) does not accept "to_char" capability. Is there a way to
reproducethe same query without using to_char function ?<br /><br />Here is my query:<br />SELECT 
to_char(quando,'dd/MM/yyyyHH24:MI'),count(id) <br />FROM base.tentativa<br />WHERE  (SESSAO_ID = 15) <br />GROUP BY
to_char(quando,'dd/MM/yyyyHH24:MI')<br />order by 1<br /><br />Regards ...<br clear="all" /><br />-- <br />
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-<br
/>                                  Atenciosamente(Sincerely)<br />                        Ezequias Rodrigues da
Rocha<br/> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-<br />A pior das democracias ainda é
melhordo que a melhor das ditaduras <br />The worst of democracies is still better than the better of dictatorships<br
/><ahref="http://ezequiasrocha.blogspot.com/">http://ezequiasrocha.blogspot.com/</a> 

pgsql-sql by date:

Previous
From: MaXX
Date:
Subject: Re: Help with optional parameters
Next
From: Niklas Johansson
Date:
Subject: Re: Group by minute