Posted: Mon Feb 12, 2018 6:24 pm Post subject: Extract seconds from XSD:DURATION datatype
Newbie
Joined: 12 Feb 2018 Posts: 1
Version: IIB10
I am trying to extract SECONDS from the XSD:DURATION datatype. As per the documentation, it's possible using EXTRACT SECOND FROM option. But I am struggling to get this working.
I am trying like:
Code:
SET SecondsFromDuration = EXTRACT (SECOND FROM DowntimeDuration);
Hi...EXTRACT only supports valid ESQL datetime data types, in this case you would try converting the incoming value to an INTERVAL type and then use EXTRACT on that value.
n this case you would try converting the incoming value to an INTERVAL type and then use EXTRACT on that value.
The SOAP and XMLNSC parser can both do that for you...if you set the 'Build tree using XML Schema data types' option. It's the default for SOAP, but it is *not* the default for XMLNSC (to ensure backward compatibility with pre-v6.0 versions).
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum