Insert into a date field

From: "Ezequias Rodrigues da Rocha" <ezequias(dot)rocha(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Insert into a date field
Date: 2007-02-02 13:08:16
Message-ID: 55c095e90702020508o70a561ffl8306739f311b8807@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

And notthing

Thanks in advance.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Atenciosamente (Sincerely)
Ezequias Rodrigues da Rocha
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda é melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2007-02-02 13:12:29 Re: Insert into a date field
Previous Message Shyju Narayanan 2007-02-02 07:39:09 sql