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@archonet.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