Insert into a date field - Mailing list pgsql-sql

From Ezequias Rodrigues da Rocha
Subject Insert into a date field
Date
Msg-id 55c095e90702020508o70a561ffl8306739f311b8807@mail.gmail.com
Whole thread Raw
Responses Re: Insert into a date field  (Richard Huxton <dev@archonet.com>)
List pgsql-sql
Hi list,<br /><br />I am trying to insert a record in a table with a date field but the postgresql reports me the
followingerror:<br /><br />ERROR: column "data_nascimento" is of type date but expression is of type integer <br />SQL
state:42804<br />Hint: You will need to rewrite or cast the expression.<br /><br /><br />I tryed like this:<br /><br
/><br/>'1963-09-01'<br />'1963-09-01'::date<br />1963-09-01<br clear="all" /><br />And notthing<br /><br /> Thanks in
advance.<br/>-- <br /> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=<br
/>                                  Atenciosamente(Sincerely)<br />                        Ezequias Rodrigues da
Rocha<br/> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- <br />A pior das democracias ainda
émelhor do que a melhor das ditaduras<br />The worst of democracies is still better than the better of dictatorships<br
/><ahref="http://ezequiasrocha.blogspot.com/">http://ezequiasrocha.blogspot.com/ </a> 

pgsql-sql by date:

Previous
From: Chris Browne
Date:
Subject: Re: Index Anding
Next
From: Richard Huxton
Date:
Subject: Re: Insert into a date field