| Author |
Message
|
| kash3338 |
 Posted: Wed Mar 02, 2011 6:08 am Post subject: GMT TimeStamp |
 |
|
Shaman
Joined: 08 Feb 2009
Posts: 709
Location: Chennai, India
|
Hi,
I have a requirement where in i need to set the Current Thailand Time for one particular field in my mapping, my Broker is in Singapore. Initially i took CURRENT TIMESTAMP and subtracted 1 from that (since time diff betw Thailand and Singapore is 1) and mapped the field. But later i was suggested to use the GMTTimeStamp instead of CURRENT TIMESTAMP.
Now when i tried using the GMTTIMESTAMP, i can find that i gives the current time of Singapore and not the Current GMT Time. Still i get the same Singapore time and not the GMT Time.
Is this the behaviour of GMT Time stamp? What is the difference between GMT TIME STAMP and CURRENT TIMESTAMP as they both give the same time? |
|
| Back to top |
|
 |
| lancelotlinc |
| Posted: Wed Mar 02, 2011 6:55 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
|
| Back to top |
|
|
| kash3338 |
| Posted: Wed Mar 02, 2011 9:38 am Post subject: |
|
|
Shaman
Joined: 08 Feb 2009
Posts: 709
Location: Chennai, India
|
| lancelotlinc wrote: |
Is CVT set?
|
Thanks for your response.
What is this CVT and how and where do we need to set this? |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Wed Mar 02, 2011 10:29 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| Quote: |
WebSphere Message Broker reports the time using Coordinated Universal Time (UTC), which does not account for leap seconds. However, on z/OS, the message putTime that is reported by WebSphere MQ in the MQMD header of a message does account for leap seconds, using the value specified for the number of leap seconds in the CVT field.
This inconsistency can cause:
Problems when debugging
Problems with message flows if you use timestamps to control the flow of messages
Misinformation
Solution: Set the CVT field so that it agrees with the UTC leap seconds. Alternatively, add an offset to adjust a z/OS timestamp reading. For example, add 20 seconds when getting the CURRENT_TIME in ESQL.
|
| Quote: |
| Long time zones work best when used in the Continent/City format. Similarly, on Unix systems, the TZ environment variable should be specified using the Continent/City format. |
What is the value of your CVT and TZ variables? For Broker 6.1 and previous, Olson TZ format is supported. For WMB 7 and newer, use POSIX TZ format.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| kimbert |
| Posted: Thu Mar 03, 2011 5:10 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
kash3338 said:
| Quote: |
| Now when i tried using the GMTTIMESTAMP, i can find that i gives the current time of Singapore and not the Current GMT Time. Still i get the same Singapore time and not the GMT Time. |
That sounds like a difference of several hours. I may be missing something, but I don't see how leap seconds could account for a time difference of more than a few seconds either way. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Thu Mar 03, 2011 5:32 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| kimbert wrote: |
kash3338 said:
| Quote: |
| Now when i tried using the GMTTIMESTAMP, i can find that i gives the current time of Singapore and not the Current GMT Time. Still i get the same Singapore time and not the GMT Time. |
That sounds like a difference of several hours. I may be missing something, but I don't see how leap seconds could account for a time difference of more than a few seconds either way. |
The OP is ambiguous with his quandry. Didn't say what platform was and did not respond to the query about what the TZ value is. Therefore, asking that question would indicate whether or not the platform is z/OS and even if he ever read that link.
Doesn't look like the OP know how to use Google.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| samchenchu |
| Posted: Thu Aug 22, 2013 5:22 am Post subject: |
|
|
Novice
Joined: 13 Aug 2013
Posts: 22
|
| Can any one let me know how to Set the CVT field ? |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Fri Aug 23, 2013 3:44 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| samchenchu wrote: |
| Can any one let me know how to Set the CVT field ? |
Don't open old posts. Create your own. DO YOUR OWN WORK. Read the InfoCentre or take the proper training to learn how.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
|
|
