MQSeries.net :: View topic - Current

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Current_Timestamp Issue

Current_Timestamp Issue

« View previous topic :: View next topic »

Author

Message

Lisa

Posted: Mon Oct 30, 2006 6:59 pm Post subject: Current_Timestamp Issue

Master

Joined: 07 Jun 2002
Posts: 287
Location: NJ

Hi all,
I'm running Message Broker 6.0 on a AIX server. I requested the Current_Timestamp value and I received the following result.
'2006-10-30 09:11:60'. As you can see, the seconds place has a value
of sixty. Has anyone seen this problem?

Here's my sample ESQL code:

Declare mydate char;

set mydate = length(cast(current_timestamp) -12);

Thanks, Lisa

fjb_saper

Posted: Mon Oct 30, 2006 7:09 pm Post subject:

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY

This may all come down to format precision and rounding:
Can you tell me what you would expect for
01:11:59.679 if you don't display the decimals?
You cannot go to 01:12:00 you're not quite there yet... but if you round it up you would have 01:11:60 right ?

Enjoy

_________________
MQ & Broker admin

Lisa

Posted: Mon Oct 30, 2006 7:12 pm Post subject: Current_Timestamp Issue

Master

Joined: 07 Jun 2002
Posts: 287
Location: NJ

Thanks for the quick response. I will review the code.

Lisa

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Current_Timestamp Issue

Jump to:

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

Protected by Anti-Spam ACP