MQSeries.net :: View topic - Trying to substract two time stamp values

Poli091987 · Posted: Wed Feb 06, 2013 5:52 am Post subject:

iam trying to subtract to time stamp values but getting a error.

DECLARE CurrentDate CHARACTER;
SET CurrentDate = CAST(CURRENT_TIMESTAMP AS CHARACTER FORMAT 'yyyy-MM-dd-HH.mm.ss.SSSSSS');
SET Environment.OutDateTime = CurrentDate;
DECLARE Exacttime FLOAT;
SET Exacttime = Environment.InDateTime - Environment.OutDateTime;

In this Environment.InDateTime is already has a value which was captured in the previous node .

==============================================

getting below error

<detail>
<Text>BIP2230E: Error detected whilst processing a message in node 'ebip_ent_plm_product_service_G2.Compute1'.
The message broker detected an error whilst processing a message in node 'ebip_ent_plm_product_service_G2.Compute1'. An exception has been thrown to cut short the processing of the message.
See the following messages for details of the error. : /build/slot1/S800_P/src/DataFlowEngine/ImbComputeNode.cpp: 497: ImbComputeNode::evaluate: ComIbmComputeNode: ebip_ent_plm_product_service_G2#FCMComposite_1_17
BIP2488E: ('.ebip_ent_plm_product_service_G2_Compute1.Main', '12.3') Error detected whilst executing the SQL statement ''SET Exacttime = Environment.InDateTime - Environment.OutDateTime;''.
The message broker detected an error whilst executing the given statement. An exception has been thrown to cut short the SQL program.
See the following messages for details of the error. : /build/slot1/S800_P/src/DataFlowEngine/ImbRdl/ImbRdlStatementGroup.cpp: 666: SqlStatementGroup::execute: :
BIP2439E: ('.ebip_ent_plm_product_service_G2_Compute1.Main', '12.42') : Error evaluating expression ''Environment.InDateTime - Environment.OutDateTime''.
An error occurred while evaluating an expression. Subsequent messages will contain more information about the nature of the error.
Correct the syntax of your ESQL expression in node ''.ebip_ent_plm_product_service_G2_Compute1.Main'', around line and column ''12.42'', then redeploy the message flow: Ensure that the expression is correctly formed. : /build/slot1/S800_P/src/DataFlowEngine/ImbRdl/ImbRdlBinaryExpression.cpp: 214: SqlBinaryMinus::evaluate: :
BIP2426E: Interval qualifier required for subtraction between values ''TIMESTAMP '2013-02-06 14:01:55.678918''' and ''TIMESTAMP '2013-02-06 14:02:12.107074'''.
When two datetime values are subtracted, an interval qualifier must be given. The subtraction was being performed between values ''TIMESTAMP '2013-02-06 14:01:55.678918''' and ''TIMESTAMP '2013-02-06 14:02:12.107074'''.
Ensure that a valid interval qualifier is specified. : /build/slot1/S800_P/src/DataFlowEngine/ImbRdl/ImbRdlValueOperations.cpp: 1334: ValueOperations::qualifierExpected: :</Text>
</detail>
</soapenv:Fault>