Re: date value not geting inserted properly - Mailing list pgsql-general

From Chris
Subject Re: date value not geting inserted properly
Date
Msg-id 44878D0F.6040501@gmail.com
Whole thread Raw
In response to date value not geting inserted properly  ("surabhi.ahuja" <surabhi.ahuja@iiitb.ac.in>)
List pgsql-general
surabhi.ahuja wrote:
> 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?

No - a date is a date, it's completely different from an integer.

Since this is java, the jdbc list should be able to help you a bit more
than this one.

--
Postgresql & php tutorials
http://www.designmagick.com/

pgsql-general by date:

Previous
From: Shane Ambler
Date:
Subject: Re: Problem with 'postgres' db with 8.0 on a MacBook
Next
From: "Matthew T. O'Connor"
Date:
Subject: UTF8 problem