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
Post a Comment