WSO2 DSS appends timezone information to mysql date result -


so i'm trying use dates mysql on wso2 dss. simple code

<query id="testdates" useconfig="portfolios_ds"> <sql>   select date(date) date datetest </sql> <result element="jsonobject" rowname="jsonarray">   <element column="date" name="testdate" xsdtype="date"/> </result> </query> 

so returns "2015-03-10-04:00" isn't considered valid date many libraries (momentjs in particular) , fair strange format, why care timezone without time.

does know why appending timezone, how can prevent appending of timezone dates leave on datetimes?

i able reproduce issue dss 3.5.0 version. have created public jira ticket [1]. , once fixed notify you.

in meantime workaround, suggest use xslt transformation trip off timezone information. more information how use xslt inside dss server please refer [2]

[1]. https://wso2.org/jira/browse/ds-1191

[2]. https://docs.wso2.com/display/dss350/xslt+transformation+sample


Comments

Popular posts from this blog

node.js - Mongoose: Cast to ObjectId failed for value on newly created object after setting the value -

gradle error "Cannot convert the provided notation to a File or URI" -

[C++][SFML 2.2] Strange Performance Issues - Moving Mouse Lowers CPU Usage -