Re: How to insert "date" as timestamp - Mailing list pgsql-jdbc

From Kevin Grittner
Subject Re: How to insert "date" as timestamp
Date
Msg-id s34dbd65.062@gwmta.wicourts.gov
Whole thread Raw
In response to How to insert "date" as timestamp  (Aydın Toprak <aydin.toprak@intengo.com>)
Responses Re: How to insert "date" as timestamp
List 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 by date:

Previous
From: Aydın Toprak
Date:
Subject: How to insert "date" as timestamp
Next
From: Roland Walter
Date:
Subject: Re: How to insert "date" as timestamp