X-Original-To: pgsql-sql-postgresql.org@postgresql.org
Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id 7CFE39FB38C
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 22 Sep 2006 11:18:25 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 72560-05 for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 22 Sep 2006 11:18:16 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from mail.telefor.hu (mail.telefor.hu [193.68.53.97])
	by postgresql.org (Postfix) with ESMTP id 326849FB350
	for <pgsql-sql@postgresql.org>; Fri, 22 Sep 2006 11:18:15 -0300 (ADT)
Received: from telefor-server.int.telefor-new.hu
	(telefor-server.int.telefor-new.hu [10.0.20.100])
	by mail.telefor.hu (Postfix) with ESMTP id DF3441C044;
	Fri, 22 Sep 2006 16:18:09 +0200 (CEST)
Received: from [10.0.20.33] ([10.0.20.33]) by
	telefor-server.int.telefor-new.hu with Microsoft
	SMTPSVC(6.0.3790.1830); Fri, 22 Sep 2006 16:14:41 +0200
Message-ID: <4513EFD1.1010500@telefor.hu>
Date: Fri, 22 Sep 2006 16:14:41 +0200
From: =?UTF-8?B?TWV6ZWkgWm9sdMOhbg==?= <mezei.zoltan@telefor.hu>
Organization: Telefor Kft.
User-Agent: Thunderbird 1.5.0.7 (Windows/20060909)
MIME-Version: 1.0
To: Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
CC: pgsql-sql@postgresql.org
Subject: Re: Group by minute
References: <55c095e90609220652t356c8591u412046aed091a52f@mail.gmail.com>
In-Reply-To: <55c095e90609220652t356c8591u412046aed091a52f@mail.gmail.com>
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit
X-OriginalArrivalTime: 22 Sep 2006 14:14:41.0961 (UTC)
	FILETIME=[72658190:01C6DE51]
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.305 tagged_above=0 required=5 tests=AWL, HTML_40_50,
	HTML_MESSAGE, MIME_HTML_ONLY
X-Spam-Level: 
X-Archive-Number: 200609/154
X-Sequence-Number: 26365

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000099">
Ezequias Rodrigues da Rocha wrote:
<blockquote
 cite="mid55c095e90609220652t356c8591u412046aed091a52f@mail.gmail.com"
 type="cite">Hil list,<br>
  <br>
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 ?<br>
  <br>
Here is my query:<br>
SELECT  to_char(quando,'dd/MM/yyyy HH24:MI'),count(id)
  <br>
FROM base.tentativa<br>
WHERE  (SESSAO_ID = 15) <br>
GROUP BY to_char(quando,'dd/MM/yyyy HH24:MI')<br>
order by 1<br>
  <br>
</blockquote>
That seems like a valid query in Oracle :-)<br>
<br>
Postgres have a slightly different mechanism for handling date and
time. The modified query:<br>
<br>
SELECT  date_trunc('minute', quando),count(id)
<br>
FROM base.tentativa<br>
WHERE  (SESSAO_ID = 15) <br>
-- GROUP BY to_char(quando,'dd/MM/yyyy HH24:MI')<br>
GROUP BY date_trunc('minute', quando)<br>
order by 1<br>
<br>
You should read:<br>
<a class="moz-txt-link-freetext" href="http://www.postgresql.org/docs/8.1/interactive/functions-datetime.html">http://www.postgresql.org/docs/8.1/interactive/functions-datetime.html</a><br>
<br>
Zizi<br>
</body>
</html>