date value not geting inserted properly

From: "surabhi(dot)ahuja" <surabhi(dot)ahuja(at)iiitb(dot)ac(dot)in>
To: <pgsql-jdbc(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org>
Subject: date value not geting inserted properly
Date: 2006-06-07 11:54:33
Message-ID: 8626C1B7EB748940BCDD7596134632BE398687@jal.iiitb.ac.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

i have a cloumn in my table which is date type

i parse a file to get the date from there,

and then i form a call to the stored procedure, with the above data as the parameter.

but however it seems that when i form this call, something is messing up, and the value for the birth date, getting into that field is "1969-12-31" ,
and this happens always, it inserts this value only, whtever be the input data value.

i am pasting the code that i am trying to do

stmt.setObject(i + 1, (tagV.value),
((TypeAttrib) (primaryKeyMap_.get(tMap.get(temp)))).dataType);

can u please tell as to what should the dataType be for date, isnt it 91- integer?

thanks,
regards
Surabhi

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Boguk Maxim 2006-06-07 12:04:42 Some mystery with execution plans on postgres 8.1
Previous Message A. Kretschmer 2006-06-07 11:52:27 Re: help with rules please

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2006-06-07 12:30:41 Re: date value not geting inserted properly
Previous Message Oliver Jowett 2006-06-06 05:41:12 Re: RES: PGJDBC 8 transaction problem