MQSeries.net :: View topic

harsha priya · Posted: Wed Jan 15, 2014 12:14 pm Post subject: cast

DECLARE DATE1 CHAR '09-14-1978';
DECLARE DATE2 CHAR '09/14/1978';
DECLARE DATE3 CHAR '1978-14-09';
DECLARE DB DATE;
DECLARE TEST CHAR;
SET DB = CAST (DATE1 AS DATE FORMAT 'MM-dd-yyyy');
SET TEST = EXTRACT(MONTH FROM DB);
SET DB = CAST (DATE2 AS DATE FORMAT 'MM/dd/yyyy');
SET TEST = EXTRACT(MONTH FROM DB);
SET DB = CAST (DATE3 AS DATE FORMAT 'yyyy-dd-MM');
SET TEST = EXTRACT(MONTH FROM DB);
SET OutputRoot.XMLNSC.DOB = InputRoot.XMLNSC.EXAMPLE.DB[1];
SET OutputRoot.XMLNSC.DOB = InputRoot.XMLNSC.EXAMPLE.DB[2];
SET OutputRoot.XMLNSC.DOB = InputRoot.XMLNSC.EXAMPLE.DB[3];

this is the code for CAST and below is my xml,

<EXAMPLE>
<DB>MM-dd-yyyy</DB>
<DB>MM/dd/yyyy</DB>
<DB>yyyy-dd-MM</DB>
</EXAMPLE>

can someone plz sort it out