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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
