| Author |
Message
|
| AkankshA |
 Posted: Tue Aug 29, 2006 5:28 am Post subject: CURRENT_GMTTIMESTAMP |
 |
|
Grand Master
Joined: 12 Jan 2006
Posts: 1494
Location: Singapore
|
Hi,
CURRENT_GMTTIMESTAMP is also returning local time.... is there any setting i need to do?? |
|
| Back to top |
|
 |
| AkankshA |
| Posted: Tue Aug 29, 2006 5:39 am Post subject: |
|
|
Grand Master
Joined: 12 Jan 2006
Posts: 1494
Location: Singapore
|
I am working on v6
LOCAL_TIMEZONE is not reflecting day light saving change.. its returning me 330 minute always... |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Tue Aug 29, 2006 6:56 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20768
Location: LI,NY
|
There is a checkbox on the message set asking you if you want to use DST ...
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| AkankshA |
| Posted: Tue Aug 29, 2006 9:41 pm Post subject: |
|
|
Grand Master
Joined: 12 Jan 2006
Posts: 1494
Location: Singapore
|
I tried checking that box... but no luck
Actually my broker is in india and i want to use GMT for my processings...
i even tried setting my broker's local time as GMT but of no luck
i do not want to do the conversion in eSQL (tedious job  )
is there any other way out for me.... |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Wed Aug 30, 2006 2:57 pm Post subject: Re: CURRENT_GMTTIMESTAMP |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20768
Location: LI,NY
|
| Akanksha wrote: |
Hi,
CURRENT_GMTTIMESTAMP is also returning local time.... is there any setting i need to do?? |
Check the box for the correct date and time.
use mqsiservice -t ?
This should be returning you something like depending on format when you cast to string
example for US EDT
2006-08-30T18:56:00.000000-04:00
It means that the date time is local but the offset allows you to get back to GMT:
GMT = local - offset. or in this case
2006-08-30T22:56:00.000000-00:00
Enjoy 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| AkankshA |
| Posted: Wed Aug 30, 2006 10:32 pm Post subject: [solved] GMTTIMESTAMP |
|
|
Grand Master
Joined: 12 Jan 2006
Posts: 1494
Location: Singapore
|
hi
my problem is solved... actually i was declaring it as character instead of timestamp...
d only issue is broker takes the time zone from d machine at the time i issue mqsistart and cant be chaged later
Anyways
Thanks a lot for your help |
|
| Back to top |
|
|
|
|
