Hi,
My Object is java.util.Date ... first of all;
I make an instance of the Date object
Date date = new Date();
then
I am wirting the set methods of the preparedstatement as
query.setDate(1,date);
however eclipse gives an error message, which is "The method setDate(int, Date) in the type PreparedStatement is not applicable for the arguments (int, Date)"...
<b>(but eclipse say that it can!)</b>
so sorry for stack trace but I cant even compile it yet...
I need time of the day, and the date... timezone and other staff is not important...
13/10/2005 11:30 .. or something like this is enough for me ...
Kevin Grittner wrote:
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