ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David E Jones <jone...@undersunconsulting.com>
Subject Re: Problem with TimeStamp
Date Thu, 05 Oct 2006 12:29:01 GMT

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.
>
>
>
>
>
>
>
>
>
>
>


Mime
View raw message