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
