Re: date value not geting inserted properly

Поиск
Список
Период
Сортировка
От Chris
Тема Re: date value not geting inserted properly
Дата
Msg-id 44878D0F.6040501@gmail.com
обсуждение исходный текст
Ответ на date value not geting inserted properly  ("surabhi.ahuja" <surabhi.ahuja@iiitb.ac.in>)
Список 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 по дате отправления:

Предыдущее
От: Shane Ambler
Дата:
Сообщение: Re: Problem with 'postgres' db with 8.0 on a MacBook
Следующее
От: "Matthew T. O'Connor"
Дата:
Сообщение: UTF8 problem