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 75BD29FA088 for ; Fri, 22 Sep 2006 10:52:16 -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 68795-06 for ; Fri, 22 Sep 2006 10:52:04 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.171]) by postgresql.org (Postfix) with ESMTP id 1458E9FB3B2 for ; Fri, 22 Sep 2006 10:52:03 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id 30so246880ugc for ; Fri, 22 Sep 2006 06:52:01 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=XtO4jBPnBlxZyo4gPt2yR/V6GYG5JaQ7OJbbq+ksaO/qRqcY5e+8zfg4RDCF8EFpffUzuki2316cFqAHFX2cFMXgT+6GegF21aGp6ebmFFKj4RwdFiR1Y5Sb3FLldguEqoUQIYqYF/Ds5z2H6iq7cRv420f/109TsFj15nTrz3I= Received: by 10.67.97.7 with SMTP id z7mr534256ugl; Fri, 22 Sep 2006 06:52:01 -0700 (PDT) Received: by 10.67.118.11 with HTTP; Fri, 22 Sep 2006 06:52:00 -0700 (PDT) Message-ID: <55c095e90609220652t356c8591u412046aed091a52f@mail.gmail.com> Date: Fri, 22 Sep 2006 10:52:00 -0300 From: "Ezequias Rodrigues da Rocha" To: pgsql-sql@postgresql.org Subject: Group by minute MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_7248_29125407.1158933120070" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.693 tagged_above=0 required=5 tests=AWL, HTML_40_50, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200609/152 X-Sequence-Number: 26363 ------=_Part_7248_29125407.1158933120070 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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 =3D 15) GROUP BY to_char(quando,'dd/MM/yyyy HH24:MI') order by 1 Regards ... --=20 =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D= -=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D- Atenciosamente (Sincerely) Ezequias Rodrigues da Rocha =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D= -=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D- A pior das democracias ainda =E9 melhor do que a melhor das ditaduras The worst of democracies is still better than the better of dictatorships http://ezequiasrocha.blogspot.com/ ------=_Part_7248_29125407.1158933120070 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hil list,

I have a query but my IDE (Delphi) does not accept "t= o_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 =3D 15)
GROUP BY to_c= har(quando,'dd/MM/yyyy HH24:MI')
order by 1

Regards ...

--
=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-= =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D= -=3D-=3D-=3D-=3D-
            = ;            &n= bsp;         Atenciosamente (S= incerely)
          &n= bsp;            = ; Ezequias Rodrigues da Rocha
=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-= =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D= -=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-
A pior das democracias ainda =E9 melho= r do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorshi= ps
http://ezequiasrocha.= blogspot.com/ ------=_Part_7248_29125407.1158933120070--