To Adobe: SerializeJson future enhancement

Question

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 · Answer

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)

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded