Re: Insert into a date field

Now it's ok thank you.

2007/2/2, Shoaib Mir <shoaibmir(at)gmail(dot)com>:
>
> Just tried the following way, that might help you:
>
> postgres=# create table testing (a date);
> CREATE TABLE
> postgres=# insert into testing values (to_date('1963-09-01',
> 'YYYY-MM-DD'));
> INSERT 0 1
> postgres=# select * from testing;
> a
> ------------
> 1963-09-01
> (1 row)
>
> --
> Shoaib Mir
> EnterpriseDB (www.enterprisedb.com)
>
> On 2/2/07, Richard Huxton <dev(at)archonet(dot)com> wrote:
>
> > Ezequias Rodrigues da Rocha wrote:
> > > Hi list,
> > >
> > > I am trying to insert a record in a table with a date field but the
> > > postgresql reports me the following error:
> > >
> > > ERROR: column "data_nascimento" is of type date but expression is of
> > type
> > > integer
> > > SQL state: 42804
> > > Hint: You will need to rewrite or cast the expression.
> > >
> > >
> > > I tryed like this:
> > >
> > >
> > > '1963-09-01'
> > > '1963-09-01'::date
> > > 1963-09-01
> >
> > Show us the whole statement - this doesn't look like the error to me.
> >
> > --
> > Richard Huxton
> > Archonet Ltd
> >
> > ---------------------------(end of broadcast)---------------------------
> >
> > TIP 4: Have you searched our list archives?
> >
> > http://archives.postgresql.org
> >
>
>

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Atenciosamente (Sincerely)
Ezequias Rodrigues da Rocha
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda é melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/