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/ HH24:MI'),count(id)
FROM base.tentativaWHERE (SESSAO_ID = 15) GROUP BY to_char(quando,'dd
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/ HH24:MI')
To group by minute, you can t
Ezequias Rodrigues da Rocha wrote:
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/ HH24:MI'),count(id)
FROM base.tentativa
On Fri, 2006-09-22 at 10:52 -0300, Ezequias Rodrigues da Rocha wrote:
> 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/
On Thu, Sep 14, 2006 at 05:02:25 -0700,
zqzuk <[EMAIL PROTECTED]> wrote:
>
> Hi, here i have a problem with this task...
>
> I have a table "cancellation" which stores cancelled bookings and details of
> charges etc
> and a table "bookings" which stores details of bookings, for example:
>
> ca
I am sure this is simple, but I don't get it. I am new to PGSQL, coming from
MySQL - in mysql, you can autoincrement the primary key; in postgre, I am
not sure how to do this. I have read the documentation, and tried "nextval"
as the default - I have searched for the datatype SERIAL, but I am using
> I am sure this is simple, but I don't get it. I am new to PGSQL, coming from
> MySQL - in mysql, you can autoincrement the primary key; in postgre, I am
> not sure how to do this. I have read the documentation, and tried "nextval"
> as the default - I have searched for the datatype SERIAL, but I
On 23/09/06, Richard Broersma Jr <[EMAIL PROTECTED]> wrote:
Is just shorthand notation for:
CREATE SEQUENCE foo START 1;
CREATE TABLE bar (id integer PRIMARY KEY DEFAULT nextval('bar'));
Doug, just a slight typo correction in that second line Richard gave
you (bar should be foo), it should rea
Richard Broersma Jr wrote on 22.09.2006 21:25:
I am sure this is simple, but I don't get it. I am new to PGSQL, coming from
MySQL - in mysql, you can autoincrement the primary key; in postgre, I am
not sure how to do this. I have read the documentation, and tried "nextval"
as the default - I have
On Saturday 23 September 2006 01:12, Thomas Kellerer wrote:
> Richard Broersma Jr wrote on 22.09.2006 21:25:
> >> I am sure this is simple, but I don't get it. I am new to PGSQL, coming
> >> from MySQL - in mysql, you can autoincrement the primary key; in
> >> postgre, I am not sure how to do this.
10 matches
Mail list logo
