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.
