| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Not able to see Milliseconds in database |
« View previous topic :: View next topic » |
| Author |
Message
|
| agrawalamit166 |
 Posted: Fri Dec 11, 2009 10:56 am Post subject: Not able to see Milliseconds in database |
 |
|
Voyager
Joined: 17 Aug 2009
Posts: 78
Location: NY, US
|
Hi,
I am using Databse node.
I want to insert Root.MQMD.PutTime in Timestamp column. But it shows 0 milliseconds, so please let me know how to insert Root.MQMD.PutTime in Timestamp column with milliseconds.
If Root.MQMD.PutTime= 15.54.34.920
Then in database, it shows 11-DEC-09 03.54.34.000000 PM
My query is:
INSERT INTO TABLE (REQUEST_TIMESTAMP) values(Root.MQMD.PutTime);
Please help me. |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Fri Dec 11, 2009 11:02 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
|
| Back to top |
|
|
| agrawalamit166 |
| Posted: Fri Dec 11, 2009 11:05 am Post subject: |
|
|
Voyager
Joined: 17 Aug 2009
Posts: 78
Location: NY, US
|
| Quote: |
| Why do you think the PutTime contains milliseconds? |
After debugging i came to know that is contains millisecond.
in debugging, The value of Root.MQMD.PutTime is .....
| Code: |
PutTime:TIME:java.util.GregorianCalendar[time=-62167392636080,
areFieldsSet=false,areAllFieldsSet=false,lenient=true,
zone=sun.util.calendar.ZoneInfo[id="America/New_York",offset=-18000000,
dstSavings=3600000,useDaylight=true,transitions=235,
lastRule=java.util.SimpleTimeZone[id=America/New_York,offset=-18000000,
dstSavings=3600000,useDaylight=true,startYear=0,startMode=3,
startMonth=2,startDay=8,startDayOfWeek=1,startTime=7200000,
startTimeMode=0,endMode=3,endMonth=10,endDay=1,
endDayOfWeek=1,endTime=7200000,endTimeMode=0]],
firstDayOfWeek=1,minimalDaysInFirstWeek=1,
ERA=0,YEAR=2,MONTH=11,WEEK_OF_YEAR=?,WEEK_OF_MONTH=?,
DAY_OF_MONTH=31,DAY_OF_YEAR=?,DAY_OF_WEEK=?,
DAY_OF_WEEK_IN_MONTH=?,AM_PM=1,HOUR=6,HOUR_OF_DAY=18,
MINUTE=49,SECOND=23,MILLISECOND=920,ZONE_OFFSET=?,
DST_OFFSET=?] |
[moderator]edited for readability[/moderator] |
|
| 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
|
|
|
|
