From: | Peter(dot)Zoche(at)materna(dot)de |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | newbie question to setTimestamp( int parameterIndex, Timestamp x, Calendar cal) |
Date: | 2005-07-19 10:49:18 |
Message-ID: | 3617A3C21370D045B75C0A40A7A6530D0B37E17E@ntexc2buc.do-office.buc.materna.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hi all!
I am new to postgresql and i have the following question:
how does setTimestamp( int parameterIndex, Timestamp x, Calendar cal) work?
why is there a parameter Timestamp? I have a Calendar in my java code and I
would like to store it in the database via a PreparedStatement. So for
example:
I have the following table:
CREATE TABLE dates( date TIMESTAMP WITH TIME ZONE );
Java code:
PreparedStatement ps = connection.prepareStatement( "INSERT INTO
dates (date) VALUES ?");
ps.setTimestamp( 1, new Timestamp(), myCalendar );
Is this correct? But why is there a Timestamp parameter? It seems clear that
the
calendar should be converted into a timestamp because the method is named
setTimestamp. I am really confused about this.
Please help
Peter
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2005-07-19 11:00:20 | Re: newbie question to setTimestamp( int parameterIndex, Timestamp x, Calendar cal) |
Previous Message | im i | 2005-07-19 10:47:00 | Re: org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block |