Try this:
'1/9/1963'
I'm interpreting your date to be January 9, 1963.
-R
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ezequias
Rodrigues da Rocha
Sent: Friday, February 02, 2007 7:08 AM
To: pgsql-sql@postgresql.org
Subject: [SQL] I
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
