Re: Group by minute
От
Scott Marlowe
Тема
Re: Group by minute
Дата
Msg-id
1158936962.5218.4.camel@localhost.localdomain
Ответ на
Group by minute (Ezequias Rodrigues da Rocha)
Список
Дерево обсуждения
Group by minute "Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com>
Re: Group by minute Scott Marlowe <smarlowe@g2switchworks.com>
How to autoincrement a primary key... "Doug Hyde" <doug.hyde@e-cocreate.com>
Re: How to autoincrement a primary key... Richard Broersma Jr <rabroersma@yahoo.com>
Re: How to autoincrement a primary key... "Andrew Chilton" <andychilton@gmail.com>
Re: How to autoincrement a primary key... Thomas Kellerer <spam_eater@gmx.net>
Re: How to autoincrement a primary key... Aarni Ruuhimäki <aarni@kymi.com>
Re: Group by minute Mezei Zoltán <mezei.zoltan@telefor.hu>
Re: Group by minute Niklas Johansson <spot@tele2.se>
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/yyyy HH24:MI'),count(id) > FROM base.tentativa > WHERE (SESSAO_ID = 15) > GROUP BY to_char(quando,'dd/MM/yyyy HH24:MI') > order by 1 > Assuming that your IDE has the same issues with date_trunc, you could always put things into a view... in psql do something like: create view frozen_caveman_ide as SELECT to_char(quando,'dd/MM/yyyy HH24:MI'), count(id) FROM base.tentativa GROUP BY to_char(quando,'dd/MM/yyyy HH24:MI'); then just call the view when you need that.
В списке pgsql-sql по дате отправления
