Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Group by minute
- From: Niklas Johansson <spot(at)tele2(dot)se>
- To: "Ezequias Rodrigues da Rocha" <ezequias(dot)rocha(at)gmail(dot)com>
- Cc: pgsql-sql(at)postgresql(dot)org
- Subject: Re: Group by minute
- Date: Fri, 22 Sep 2006 16:10:54 +0200
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/yyyy HH24:MI')
To group by minute, you can try
GROUP BY date_trunc('minute', quando)
or even
GROUP BY EXTRACT(EPOCH FROM quando)::integer / 60
Sincerely,
Niklas Johansson
- References:
- Group by minute
- From: Ezequias Rodrigues da Rocha
- Group by minute
- Prev by Date: Group by minute
- Next by Date: Re: Group by minute
- Previous by thread: Group by minute
- Next by thread: Re: Group by minute
- Indexes: