From: Niklas Johansson <spot@tele2.se>
To: Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Group by minute
Date: Fri, 22 Sep 2006 16:10:54 +0200
Message-ID: <F65F089C-5162-49EE-9D17-0F8ACA48ADE6@tele2.se> (raw)
In-Reply-To: <55c095e90609220652t356c8591u412046aed091a52f@mail.gmail.com>
References: <55c095e90609220652t356c8591u412046aed091a52f@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: spot@tele2.se, ezequias.rocha@gmail.com
Subject: Re: Group by minute
In-Reply-To: <F65F089C-5162-49EE-9D17-0F8ACA48ADE6@tele2.se>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox