| Author |
Message
|
| samchenchu |
 Posted: Wed Aug 21, 2013 2:52 am Post subject: UK TIME STAMP in esql |
 |
|
Novice
Joined: 13 Aug 2013
Posts: 22
|
Hi,
How to get the UK timestamp from ESQL when the broker is in CST. |
|
| Back to top |
|
 |
| lancelotlinc |
| Posted: Wed Aug 21, 2013 3:40 am Post subject: Re: UK TIME STAMP in esql |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| samchenchu wrote: |
Hi,
How to get the UK timestamp from ESQL when the broker is in CST. |
GMTTIME - Use Google. Your answer is in the InfoCentre. You must be responsible for your own work. Don't ask other people to do it for you.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| samchenchu |
| Posted: Wed Aug 21, 2013 3:42 am Post subject: UK TIME STAMP in esql |
|
|
Novice
Joined: 13 Aug 2013
Posts: 22
|
Hi friends,
The UK timestamp is equivalent to GMT +1 hour. I have taken the CURRENT_GMTTIMESTAMP and added 1 hour interval as "CURRENT_GMTTIMESTAMP + INTERVAL '1' HOUR".
But this is not equivalent to UK local time zone.
Can any one please guide me how to solve this. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Wed Aug 21, 2013 3:43 am Post subject: Re: UK TIME STAMP in esql |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| samchenchu wrote: |
Hi friends,
The UK timestamp is equivalent to GMT +1 hour. I have taken the CURRENT_GMTTIMESTAMP and added 1 hour interval as "CURRENT_GMTTIMESTAMP + INTERVAL '1' HOUR".
But this is not equivalent to UK local time zone.
Can any one please guide me how to solve this. |
LOOK IT UP. THATS WHAT DOCUMENTATION IS FOR. DO YOUR OWN WORK. QUIT ASKING PEOPLE TO USE GOOGLE FOR YOU.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Wed Aug 21, 2013 3:55 am Post subject: Re: UK TIME STAMP in esql |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
| samchenchu wrote: |
But this is not equivalent to UK local time zone.
|
What do you think is 'UK Local Time'?
Can we have an example of what you mean?
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| Tibor |
| Posted: Wed Aug 21, 2013 3:55 am Post subject: |
|
|
Grand Master
Joined: 20 May 2001
Posts: 1033
Location: Hungary
|
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Wed Aug 21, 2013 4:03 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
Tibor - so every time our friend Sam needs to look up something in the InfoCentre, will you be his gopher? Of what use is it to provide a Google search for him? Is he not capable of doing his own work?
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| Tibor |
| Posted: Wed Aug 21, 2013 4:27 am Post subject: |
|
|
Grand Master
Joined: 20 May 2001
Posts: 1033
Location: Hungary
|
Sorry, I didn't know, it would be problem... you know some guys have a sort of dys* functions...
Moreover I think it was definitely less effort for me than the whole grumpy fighting on your side.  |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Wed Aug 21, 2013 4:28 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| Tibor wrote: |
Sorry, I didn't know, it would be problem... you know some guys have a sort of dys* functions...
Moreover I think it was definitely less effort for me than the whole grumpy fighting on your side. |
It seems to be "that time of year" again, when a bunch of freshers get jobs and have no clue how to do the job they are getting paid for.
| mqjeff wrote: |
| gakd1987 wrote: |
| If ur interested please help me.. |
I am trying to help you.
I am trying to help you understand that you need to go off and do your own learning.
This is not at teaching place. This is twice as poor a place for people who want teaching but then refuse to learn. |
The regulations define a "specialty occupation" as requiring theoretical and practical application of a body of highly specialized knowledge in a field of human endeavor. If they don't know how to use Google, I'm not sure how long their status will hold up under scrutiny.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| Tibor |
| Posted: Wed Aug 21, 2013 4:36 am Post subject: |
|
|
Grand Master
Joined: 20 May 2001
Posts: 1033
Location: Hungary
|
| Quote: |
| It seems to be "that time of year" again, when a bunch of freshers get jobs and have no clue how to do the job they are getting paid for. |
Agree. But I am a teacher somewhere inside, who believes, some of them might be a real MQ / MB expert once... |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Wed Aug 21, 2013 4:40 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| Tibor wrote: |
| Quote: |
| It seems to be "that time of year" again, when a bunch of freshers get jobs and have no clue how to do the job they are getting paid for. |
Agree. But I am a teacher somewhere inside, who believes, some of them might be a real MQ / MB expert once... |
Then help them achieve that. Achieving that does not include posting requests for Google lookups on mqseries.net.
Give them your email address if you have the patience and want to be their master. Indentured servitude is a form of debt bondage.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
|
|
