Re: How to insert "date" as timestamp

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: How to insert "date" as timestamp
Дата
Msg-id s34dbd65.062@gwmta.wicourts.gov
обсуждение исходный текст
Ответ на How to insert "date" as timestamp  (Aydın Toprak <aydin.toprak@intengo.com>)
Ответы Re: How to insert "date" as timestamp  (Roland Walter <rwa@mosaic-ag.com>)
Список pgsql-jdbc
Hi,

Is your object a java.util.Date, a java.sql.Date, or a
java.sql.Timestamp?  Do you want the column in the database to
store only a date, or combined date and time?  If you want the
column to store a combined date and time, you should define it
as TIMESTAMP WITH TIME ZONE unless you have some very
unusual need to have a timestamp that represents a different
moment in each time zone.

Some sample code and your exception (with stack trace) would
help, too.

-Kevin

>>> Ayd*n Toprak <aydin.toprak@intengo.com> 10/13/05 1:20 AM >>>
hii,


I am newbie for jdbc-postgres and looking for some help about timestamp
type of posgresql.....


my porgram makes a data object, and then insert this object to the db.
however, I couldnt been able to insert date object directly to the db as
timestamp ...

do I making something wrong ? .. or is there another type to keep full
date of java, in the Postgresql Db.

Thank You.

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend


В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Aydın Toprak
Дата:
Сообщение: How to insert "date" as timestamp
Следующее
От: Roland Walter
Дата:
Сообщение: Re: How to insert "date" as timestamp