Re: Group by minute

Ezequias Rodrigues da Rocha wrote: <blockquote cite="mid55c095e90609220652t356c8591u412046aed091a52f@mail.gmail.com"
type="cite">Hillist,<br /><br /> I have a query but my IDE (Delphi) does not accept "to_char" capability. Is there a
wayto reproduce the 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 /></blockquote> That seems like a valid query in Oracle
:-)<br/><br /> Postgres have a slightly different mechanism for handling date and time. The modified query:<br /><br />
SELECT date_trunc('minute', quando),count(id) <br /> FROM base.tentativa<br /> WHERE  (SESSAO_ID = 15) <br /> -- GROUP
BYto_char(quando,'dd/MM/yyyy HH24:MI')<br /> GROUP BY date_trunc('minute', quando)<br /> order by 1<br /><br /> You
shouldread:<br /><a class="moz-txt-link-freetext"
href="http://www.postgresql.org/docs/8.1/interactive/functions-datetime.html">http://www.postgresql.org/docs/8.1/interactive/functions-datetime.html</a><br
/><br/> Zizi<br />