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
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 |
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 |