Forum Post: Re: Format Of Json Value

  • Thread starter Thread starter Peter Judge
  • Start date Start date
Status
Not open for further replies.
P

Peter Judge

Guest
There are a couple of settings to look at, most are startup params and settable attributes on the SESSION handle. DATE-FORMAT TIME-SOURCE YEAR-OFFSET Once you have a date you can format it via the STRING( , " ") function, the ISO-DATE function or you can roll your own per the below snippet, which creates a format of 2015-10-26 . when 'date' then mhSaxWriter: write-characters ( substitute ( '&1-&2-&3' , string ( year (hField: buffer-value ), '9999' ), string ( month (hField: buffer-value ), '99' ), string ( day (hField: buffer-value ), '99' ))). If you use the built-in XML serializer it follows the XML spec, and if you use the JSON serializer, it uses ISO-DATE (as you discovered). There are also NUMERIC-FORMAT and NUMERIC-DECIMAL-POINT attributes for working with numbers.

Continue reading...
 
Status
Not open for further replies.
Back
Top