Insert into a date field
От | Ezequias Rodrigues da Rocha |
---|---|
Тема | Insert into a date field |
Дата | |
Msg-id | 55c095e90702020508o70a561ffl8306739f311b8807@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Insert into a date field
|
Список | 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 по дате отправления: