2

I'm having trouble with this code snippet:

DECLARE FormattedTimeStamp TIMESTAMP;
DECLARE pattern CHARACTER 'yyyy-mm-ddTHH:mm:ss';
SET FormattedTimeStamp = CAST(EnvRef.ConsumerTrxnsInq.paymentList[i].TransactionDate as DATE FORMAT 'yyyy-MM-dd');
SET OutputRoot.XMLNSC.ns:ConsumerTrxnsInqRs.Body.ConsumerTransaction[i].Timestamp = CAST(REPLACE(SUBSTRING(CAST(FormattedTimeStamp AS CHAR) before '.'),' ','T') AS TIMESTAMP FORMAT pattern);

When I run it, it produces this error:

Error while casting. subParse failed. TIMESTAMPT'2014-12-02T15:39:21. yyyy-mm-ddTHH:mm:ss. TIMESTAMPT'2014-12-02T15:39:21. yyyy.

Any help?

Jonathan Leffler
  • 730,956
  • 141
  • 904
  • 1,278
seeker
  • 79
  • 2
  • 16

2 Answers2

2

There is issue with you'r pattern you defined. Please correct it as following.. It should work..

  DECLARE pattern CHARACTER 'yyyy-MM-dd''T''HH:mm:ss';
Imran
  • 5,376
  • 2
  • 26
  • 45
0

If you work with T-SQL, then First of all replace 

DECLARE FormattedTimeStamp TIMESTAMP

with 

DECLARE @FormattedTimeStamp TIMESTAMP
Yuriy Zaletskyy
  • 4,983
  • 5
  • 34
  • 54