To Adobe: SerializeJson future enhancement

[Doug_E_Fresh]

To the CF team -

Please add an enhancement that allows us to select a datetime format for those date/time fields in our queries / structs.

There are times when I want to maintain the data exactly from my database so that it shows the same way in my SerializeJSON output.

Give me an option to select which dateformat to send to the client.

Thanks

[James Moberg]

How are you currently working around this issue?

Apparently serializejson() converts ColdFusion dates & times into strings that can be easily parsed by the JavaScript "Date" object. (withdrawn; "asDesigned")

My approach has been to use MSSQL query to use CONVERT to return timestamps as ISO8601 UTC VARCHAR strings using "SELECT CONVERT(VARCHAR(23), MyUTCDateColumn, 126) AS ISODateString".

If this enhancement doesn't exist in the bug tracker, please submit it and I'll upvote it.
https://tracker.adobe.com/

Here are some related bugs/requests:

• https://tracker.adobe.com/#/view/CF-4214825 ("Date/time serialization loses time zone" - investigate 1.5yrs)
• https://tracker.adobe.com/#/view/CF-4212660 ("serializeJSON mangles date values" - investigate 2yrs)
• https://tracker.adobe.com/#/view/CF-4206236 ("Timestamp format" - withdrawn)