| Author |
Message
|
| DELLIPIZ |
 Posted: Wed Sep 14, 2005 6:41 pm Post subject: Timestamp problem |
 |
|
Acolyte
Joined: 08 Oct 2003
Posts: 70
|
Hi,
I am using the CURRENT TIMESTAMP function within WMQI 2.1. And the timestamp I am getting is 1 hour earlier than the EDT time I was expecting:
I got 2005-09-14-20.58.52.051077... but it was really 21:58
Any suggestions of how I could handle it? I am thinking that it might be an issue just during EDT, but still I need to work around it.
I thought it was suggested to use DB timestamps. Any suggestion of how I could use DB2 on MVS? Sampe ESQL would be appreciated!
Thanks!  |
|
| Back to top |
|
 |
| JT |
| Posted: Wed Sep 14, 2005 8:24 pm Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
|
| Back to top |
|
|
| DELLIPIZ |
| Posted: Thu Sep 15, 2005 9:10 am Post subject: |
|
|
Acolyte
Joined: 08 Oct 2003
Posts: 70
|
Hi,
Yes, this is MVS.
Thanks!
-Lori |
|
| Back to top |
|
|
| JT |
| Posted: Thu Sep 15, 2005 4:40 pm Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
See if this will do the trick:
| Code: |
| SELECT current timestamp FROM sysibm.sysdummy1 |
|
|
| Back to top |
|
|
| DELLIPIZ |
| Posted: Thu Sep 15, 2005 8:20 pm Post subject: |
|
|
Acolyte
Joined: 08 Oct 2003
Posts: 70
|
Hi,
Both
SET HOLD_DATE_TIME_TS = SELECT current timestamp FROM sysibm.sysdummy1;
AND
SET HOLD_DATE_TIME_TS = SELECT CURRENT_TIMESTAMP FROM sysibm.sysdummy1;
cause syntax errors.
-Lori |
|
| Back to top |
|
|
| Tibor |
| Posted: Fri Sep 16, 2005 1:13 am Post subject: |
|
|
Grand Master
Joined: 20 May 2001
Posts: 1033
Location: Hungary
|
|
| Back to top |
|
|
| JT |
| Posted: Fri Sep 16, 2005 6:23 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
This ESQL......
| Code: |
SET Environment.Variables.HOLD_DATE_TIME_TS[] =
PASSTHRU('SELECT current timestamp FROM sysibm.sysdummy1'); |
produced these results.......
| Code: |
(0x01000000):Variables = (
(0x01000000):HOLD_DATE_TIME_TS = (
(0x03000000):Column0 = TIMESTAMP '2005-09-16 10:19:48.180484'
)
)
|
|
|
| Back to top |
|
|
|
|
