Quotes

Wednesday, October 12, 2016

Convert Integer to date ESQL

DECLARE source INTEGER 20150401;
--DECLARE target CHARACTER;
--DECLARE pattern CHARACTER '00000000';
SET OutputRoot.XMLNSC.target = CAST(CAST(CAST(source AS CHARACTER FORMAT '00000000')AS DATE FORMAT 'yyyyMMdd')AS CHARACTER FORMAT 'yyyy-MM-dd') ||'T00:00:00.000';

No comments:

Post a Comment