Search Postgresql Archives

Re: date value not geting inserted properly

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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/


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux