| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| TimeStamp Difference |
« View previous topic :: View next topic » |
| Author |
Message
|
| RocknRambo |
 Posted: Tue Oct 26, 2004 11:19 am Post subject: TimeStamp Difference |
 |
|
Partisan
Joined: 24 Sep 2003
Posts: 355
|
I 'm trying to get the time zone difference with ref to GMT..
like with difference between CURRENT_TIME and CURRENT_GMTTIME,
but facing pblms with the Day Light savings...
for ex:
in the input message, if the date is current date, I provide the current and time and time difference. (-4 GMT) works fine...
but if the date is a POST DATE like 15th NOV, which is after Day light savings, = (-5 GMT)
the value of CURRENT_GMTTIME - CURRENT_TIME = -4
so the option we thought is to hav a db lookup to figure the date, whether for DayLight saving complaint and accordingly hardcode -4 or -5 GMT
any better thoughts..to implement.
-RR |
|
| Back to top |
|
 |
| kirani |
| Posted: Tue Oct 26, 2004 5:14 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
I think LOCAL_TIMEZONE function might help.
| Quote: |
The LOCAL_TIMEZONE datetime function returns the displacement of the local time zone from GMT.
LOCAL_TIMEZONE returns an interval value representing the local time zone displacement from GMT. As with all SQL functions that take no parameters, no parentheses are required or accepted. The value returned is an interval in hours and minutes representing the displacement of the current time zone from Greenwich Mean Time. The sign of the interval is such that a local time can be converted to a time in GMT by subtracting the result of the LOCAL_TIMEZONE function.
|
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| RocknRambo |
| Posted: Tue Oct 26, 2004 6:55 pm Post subject: |
|
|
Partisan
Joined: 24 Sep 2003
Posts: 355
|
Yes ur correct ...LOCAL_TIMEZONE function gives the value but
The Pblm I have is.... this for production planning to ship goods...I hav to provide the time difference for the date in the input message.
now if the Date is a Post Date, like 15th of Nov, and the time 00:00 hours
so it Provides -04 hours.... but reality
on 15th Nov it would be -05 hours.
which results...14th Nov
any thoughts..to share
-RR |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Oct 27, 2004 4:53 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
If you are using WBIMB V5 with CSD4, you can create a static java method that will use the Java date APIs, and this will give you robust date calculations from within WBIMB.
Otherwise you will either have to code these calculations yourself in ESQL, or in a custom plug-in.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| RocknRambo |
| Posted: Wed Oct 27, 2004 5:16 am Post subject: |
|
|
Partisan
Joined: 24 Sep 2003
Posts: 355
|
We are in V5.0 but not got into CSD4, so I cannot for JAVA option...
| Quote: |
| Otherwise you will either have to code these calculations yourself in ESQL |
so you mean, check the date compatability with Day light savings, (using if conditions or so..)
then..proceed futher???
-RR |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
