| Author |
Message
|
| TBS |
 Posted: Thu Jul 05, 2007 12:06 am Post subject: CURRENT_DATE |
 |
|
Centurion
Joined: 29 Jan 2007
Posts: 143
Location: Hillerød / Denmark
|
Hi !
IF I specify
SET OutputRoot.MRM.LeveranceRettelsesDato = CURRENT_DATE;
I get different result on two different server.
Server1=2007-06-28 and Server2=28-06-2007
The languish on the two server is different.
Where do the CURRENT_DATE get the format from ? |
|
| Back to top |
|
 |
| Vitor |
| Posted: Thu Jul 05, 2007 12:17 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
Locale setting of the host machine
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| TBS |
| Posted: Thu Jul 05, 2007 12:26 am Post subject: Current_Date |
|
|
Centurion
Joined: 29 Jan 2007
Posts: 143
Location: Hillerød / Denmark
|
Yes i Suppose so but when i type DATE on the Windows server on a CMD window i get the same resoult on both machine
D:\WMB>date
The current date is: 05-07-2007
Enter the new date: (dd-mm-yy) |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Jul 05, 2007 12:28 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
Does the DATE command use the same locale environment variables for control as the broker does? 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| TBS |
| Posted: Thu Jul 05, 2007 12:30 am Post subject: |
|
|
Centurion
Joined: 29 Jan 2007
Posts: 143
Location: Hillerød / Denmark
|
| Probely not but where do the Broker the get the format from ? |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Jul 05, 2007 12:35 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
It's based on the host machine locale. Described in the ESQL manual IIRC.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| TBS |
| Posted: Thu Jul 05, 2007 12:49 am Post subject: |
|
|
Centurion
Joined: 29 Jan 2007
Posts: 143
Location: Hillerød / Denmark
|
Thanks  Where d0o i find the ESQL manual IIRC ? |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Jul 05, 2007 1:40 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
Documentation button at the top of this page will take you to the IBM web site library home page. This contains all the MQ & WMB documentation.
And IIRC is If I Remember Correctly - it may not be that manual but one of the others. Been I while since I looked! 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Thu Jul 05, 2007 1:04 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| TBS wrote: |
| Probely not but where do the Broker the get the format from ? |
I believe the date format comes from the time zone and date formatting of the broker's service user....
So if the broker's service user on one machine shows a European date format and on the other machine an American date format, this is what you get by default in the broker.
To check out more you can use mqsiservice with one of its flags and it should display you the date and time + timezone the broker believes it uses....
Enjoy
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| AkankshA |
| Posted: Fri Jul 06, 2007 12:19 am Post subject: |
|
|
Grand Master
Joined: 12 Jan 2006
Posts: 1494
Location: Singapore
|
mqsiservice -t shall gv u the detailed time zone info
_________________
Cheers |
|
| Back to top |
|
|
|
|
