Group by minute
От | Ezequias Rodrigues da Rocha |
---|---|
Тема | Group by minute |
Дата | |
Msg-id | 55c095e90609220652t356c8591u412046aed091a52f@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Group by minute
Re: Group by minute Re: Group by minute |
Список | 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 по дате отправления: