From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
---|---|
To: | Ravi Periasamy <ravitx12(at)yahoo(dot)com> |
Cc: | Oliver Jowett <oliver(at)opencloud(dot)com>, pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: issues with Statement.getTimestamp(int, Calendar) |
Date: | 2006-12-13 11:38:09 |
Message-ID: | A9D6BB90-DD18-4E58-A7F6-E6DEFF106869@fastcrypt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Ravi,
what is your time zone from what you have my guess would be -9:00 ?
I think the JVM adjusts the actual time to your local timezone when
it prints it.
Dave
On 12-Dec-06, at 11:05 PM, Ravi Periasamy wrote:
> The test case is as follows.
>
> I created a function as follows:
> ==================================================
> create or replace function testouttimestamp(OUT a1
> timestamp) AS $$
> begin
> a1 := '1970-01-01 00:00:00';
> end;
> $$ language plpgsql;
> ==================================================
>
> and called through JDBC as follows:
> ==================================================
> TimeZone tz = TimeZone.getTimeZone("GMT");
> Calendar cr = Calendar.getInstance(tz);
> CallableStatement stmt = con.prepareCall( "{call
> testouttimestamp(?)}");
> stmt.registerOutParameter(1, Types.TIMESTAMP);
> stmt.execute();
> Timestamp ts = stmt.getTimestamp(1, cr);
> System.out.println("ts = " + ts);
> ==================================================
>
> Actual Result ==>
> 1969-12-31 18:30:00.0
>
> Expected Result ==>
> 1970-01-01 05:30:00.0
>
> Note: ResultSet.getTimestamp(int, Calendar) works
> fine.
>
> Thanks
> Ravi
>
> --- Oliver Jowett <oliver(at)opencloud(dot)com> wrote:
>
>> Ravi Periasamy wrote:
>>> Dear PSQL-JDBC team,
>>>
>>> There is a issue with Statement.getTimestamp(int,
>>> Calendar). The timestamp is offset in the wrong
>>> direction.
>>>
>>> The quivalent on ResultSet.getTimestamp(int,
>> Calendar)
>>> works fine.
>>>
>>> Is this a known bug, can we expect a fix for this,
>>> when?
>>
>> Can you send a testcase demonstrating the problem
>> please?
>>
>> -O
>>
>
>
>
>
> ______________________________________________________________________
> ______________
> Want to start your own business?
> Learn how on Yahoo! Small Business.
> http://smallbusiness.yahoo.com/r-index
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>
From | Date | Subject | |
---|---|---|---|
Next Message | Ravi Periasamy | 2006-12-13 11:47:18 | Re: issues with Statement.getTimestamp(int, Calendar) |
Previous Message | Ravi Periasamy | 2006-12-13 04:05:07 | Re: issues with Statement.getTimestamp(int, Calendar) |