To Adobe: SerializeJson future enhancement

Report · Mar 12, 2024

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

Report · Mar 12, 2024

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)