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

Distributed Computing: A Guide to Comparing Data Between Hive Tables Using Spark

In big data, efficient data comparison is essential for ensuring data integrity and validating data migrations. Apache Spark, with its in-me...