g
Subject: [SQL] Insert into a date field
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 ne
Now it's ok thank you.
2007/2/2, Shoaib Mir <[EMAIL PROTECTED]>:
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',
'-MM-DD'));
INSERT 0 1
postgres=# select * from testing;
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', '-MM-DD'));
INSERT 0 1
postgres=# select * from testing;
a
1963-09-01
(1 row)
--
Shoaib Mir
EnterpriseDB (ww
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 th
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:
