[jira] Commented: (OPENJPA-1480) time zone info lost when using timestamp field

["Craig Russell (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/OPENJPA-1480?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12803859#action_12803859 ] 

Craig Russell commented on OPENJPA-1480:
----------------------------------------

What is the database type for storing these timestamp values? Is there a column with the time zone? Where would you store the time zone information in the database?

> time zone info lost when using timestamp field
> ----------------------------------------------
>
>                 Key: OPENJPA-1480
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-1480
>             Project: OpenJPA
>          Issue Type: Bug
>          Components: jdbc
>    Affects Versions: 1.2.3, 2.0.0-M3
>         Environment: at least DB2, Derby, Sybase
>            Reporter: B.J. Reed
>            Priority: Minor
>             Fix For: 1.2.3, 2.0.0-M3
>
>         Attachments: TestTimeZone.java, TZDataModel.java
>
>
> Looks like OpenJPA always gets the time stamp out at the time zone of the machine, not the time zone that was used originally.
> The test case is putting in 2 TimeStamps
>     TTimestamp = 4-3-2004 21:0:0.0 (America/New_York)
>     TTimestampUTC = 4-4-2004 2:0:0.0 (UTC)
> When OpenJPA gets those 2 timesamps back out of the database, they are 
>     TTimestamp = 4-3-2004 21:0:0.0 (America/New_York)
>     TTimestampUTC = 4-3-2004 21:0:0.0 (America/New_York)

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Re: How to unsubscribe

[Kevin Sutter <kw...@gmail.com>]

Hi Evan,
All you need to do is send an email to dev-unsubscribe@openjpa.apache.org[1].

It was good "working" with you.  :-)

Kevin
[1]  http://openjpa.apache.org/mailing-lists.html

On Tue, Feb 2, 2010 at 1:36 PM, Evan Ireland <ei...@sybase.com> wrote:

> Folks,
>
> Sadly, I don't seem to have time anymore to follow this mailing list.
>
> Can someone please point me to unsubscribe instructions?
>
> Thanks.
>
>

How to unsubscribe

[Evan Ireland <ei...@sybase.com>]

Folks,

Sadly, I don't seem to have time anymore to follow this mailing list.

Can someone please point me to unsubscribe instructions?

Thanks.