OFBiz › OFBiz - User

Problem with TimeStamp

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

3 messages Options

Tushar Abhyankar

Problem with TimeStamp

Hi Everyone ,

I have this problem, when I am fetching a record from the database the
timestamp is exactly 30 min ahead of the persisted timestamp.

For instance the fetched data for a particular PartyContactMech is

[fromDate,2006-10-05 11:30:18.269(java.sql.Timestamp)]

But the persisted fromDate timestamp in PartyContactMech is

fromDate- 2006-10-05 11:00:18.269+05:30

Log when we fetch PartyContactMech

[GenericEntity:PartyContactMech][allowSolicitation,null()][comments,null()][

contactMechId,10601(java.lang.String)

][createdStamp,2006-10-05

11:30:18.27(java.sql.Timestamp)][createdTxStamp,2006-10-05 11:30:17.503(ja

va.sql.Timestamp)][extension,null()][fromDate,2006-10-05

11:30:18.269(java.sql.Timestamp)][lastUpdat

edStamp,2006-10-05

11:30:18.27(java.sql.Timestamp)][lastUpdatedTxStamp,2006-10-05

11:30:17.503(java.

sql.Timestamp)][monthsWithContactMech,null()][partyId,10600(java.lang.String

)][roleTypeId,null()][th

ruDate,null()][yearsWithContactMech,null()]]

And the same data of party in partyContactMech Table View is:

partyId- 10600

contactMechId- 10601

fromDate- 2006-10-05 11:00:18.269+05:30

thruDate- <NULL>

lastUpdatedStamp- 2006-10-05 11:00:17.503+05:30

lastUpdatedTxStamp- 2006-10-05 11:00:18.27+05:30

createdStamp- 2006-10-05 11:00:18.27+05:30

createdTxStamp- 2006-10-05 11:00:17.503+05:30

Does anyone have any idea about why this is happening?

Regards,

Tushar.

David E Jones-2

Re: Problem with TimeStamp

Looks like time zone stuff. Which database and operating system are
you using?

-David

On Oct 5, 2006, at 1:20 PM, Tushar Abhyankar wrote:

> Hi Everyone ,
>
>
>
> I have this problem, when I am fetching a record from the database the
> timestamp is exactly 30 min ahead of the persisted timestamp.
>
>
>
> For instance the fetched data for a particular PartyContactMech is
>
> [fromDate,2006-10-05 11:30:18.269(java.sql.Timestamp)]
>
>
>
> But the persisted fromDate timestamp in PartyContactMech is
>
> fromDate- 2006-10-05 11:00:18.269+05:30
>
>
>
>
>
> Log when we fetch PartyContactMech
>
> [GenericEntity:PartyContactMech][allowSolicitation,null()]
> [comments,null()][
>
> contactMechId,10601(java.lang.String)
>
> ][createdStamp,2006-10-05
>
> 11:30:18.27(java.sql.Timestamp)][createdTxStamp,2006-10-05
> 11:30:17.503(ja
>
> va.sql.Timestamp)][extension,null()][fromDate,2006-10-05
>
> 11:30:18.269(java.sql.Timestamp)][lastUpdat
>
> edStamp,2006-10-05
>
> 11:30:18.27(java.sql.Timestamp)][lastUpdatedTxStamp,2006-10-05
>
> 11:30:17.503(java.
>
> sql.Timestamp)][monthsWithContactMech,null()][partyId,10600
> (java.lang.String
>
> )][roleTypeId,null()][th
>
> ruDate,null()][yearsWithContactMech,null()]]
>
>
>
> And the same data of party in partyContactMech Table View is:
>
>
>
> partyId- 10600
>
> contactMechId- 10601
>
> fromDate- 2006-10-05 11:00:18.269+05:30
>
> thruDate- <NULL>
>
> lastUpdatedStamp- 2006-10-05 11:00:17.503+05:30
>
> lastUpdatedTxStamp- 2006-10-05 11:00:18.27+05:30
>
> createdStamp- 2006-10-05 11:00:18.27+05:30
>
> createdTxStamp- 2006-10-05 11:00:17.503+05:30
>
>
>
> Does anyone have any idea about why this is happening?
>
>
>
> Regards,
>
> Tushar.
>
>
>
>
>
>
>
>
>
>
>

Tushar Abhyankar

RE: Problem with TimeStamp

I am using Windows XP as an Operating System and postgre SQL as Database.

Regards,
Tushar

-----Original Message-----
From: David E Jones [mailto:[hidden email]]
Sent: Thursday, October 05, 2006 5:59 PM
To: [hidden email]
Subject: Re: Problem with TimeStamp

Looks like time zone stuff. Which database and operating system are
you using?

-David

On Oct 5, 2006, at 1:20 PM, Tushar Abhyankar wrote: