tracker issue : CF-3852070

select a category, or use search below
(searches all categories and all time range)
Title:

Incorrect Serialization of dates

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/

Reporter/Name(from Bugbase): Gary Gilbert / Gary Gilbert (garyrgi)

Created: 11/14/2014

Components: AJAX, Plumbing

Versions: 10.0

Failure Type:

Found In Build/Fixed In Build: Final / CF11 Update5,CF10 Update16

Priority/Frequency: Major / Some users will encounter

Locale/System: English / Platforms All

Vote Count: 1

Listed in the version 11.0.05.293506 Issues Fixed doc
Problem Description:
ColdFusion incorrectly serializes dates using serializeJson in different system Locales.  SerializeJson should convert a date to a date that javascript can parse. According to the online documentation “The SerializeJSON function converts the ColdFusion date time object for October 3, 2007 at 3:01 PM, for example, into the JSON string "October, 03 2007 15:01:00"

Example Date =  {ts '2014-10-03 15:01:00'} 
A Default Java Locale of any non-English locale produces incorrect MONTH names.
e.g. with default locale of de_DE
"Oktober, 03 2014 15:01:00"
e.g. with default locale of es_ES
"octubre, 03 2014 15:01:00" 

The produced date CANNOT be parsed by javascript!

Steps to Reproduce:
Add -Duser.language=es -Duser.country=ES to jvm.config and restart the coldfusion service

<cfoutput>
#GetLocale()#<br>
#parsedatetime(datetime)#<br>
#serializejson(parsedatetime(datetime))#
</cfoutput>

Actual Result:
"octubre, 03 2014 15:01:00" 
Expected Result:
"October, 03 2014 15:01:00" 
Any Workarounds:
Force Java default local to en_EN via jvm arguments

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3852070

Keywords:
FixTested


External Customer Info:
External Company:  
External Customer Name: garyrgi
External Customer Email:  
External Test Config: My Hardware and Environment details:

Attachments:

Comments:

language and platforms dropdowns provide only english and japanease and are required fields. Either have all language posibilities or make it optiona. App Language= german OS language = german
Comment by External U.
10082 | November 14, 2014 09:35:46 AM GMT
Vote must be between 25 and 4000 characters
Vote by External U.
10089 | November 14, 2014 09:41:08 AM GMT
forgot to add variable for datetime <cfset datetime = "October, 03 2007 15:01:00">
Comment by External U.
10083 | November 14, 2014 09:42:31 AM GMT
Furthermore the dateformat should include the GMT offset. For international systems no GMT offset information could produce dates that off by 23hrs. this would also mean that deserializejson would need to be able to parse dates that include the GMT offset e.g. "November, 17 2014 09:49:46 +0100"
Comment by External U.
10084 | November 17, 2014 05:32:16 AM GMT
@grayrgi This bug has been fixed and will be available in a future release. Could you please log a new enhancement request for having the GMT offset specified within the dateformat.
Comment by Immanuel N.
10085 | January 22, 2015 07:00:53 AM GMT
The fix for this bug is available in the pre-release build of ColdFusion 11 Update 5 and ColdFusion 10 Update 16
Comment by CFwatson U.
10086 | February 20, 2015 09:22:39 AM GMT
Yet another bug marked as fixed even though it was NOT fixed for this version of ColdFusion.
Comment by External U.
10087 | July 30, 2015 02:22:01 PM GMT
Oops, missed the comment on the Update 16... would be nice if we could edit or delete our comments
Comment by External U.
10088 | July 30, 2015 02:25:36 PM GMT