We need the ability to persist all Date types as a string in a way that consistently honors the timezone settings of the host and database, is portable across regions, and has consistent sort and search semantics.
I have made changes, and produced a patch to add this capability. And if accepted, I will produce a set of test cases also.
In addition, I have seen that these is a prior related issue
, which uses a string converter. I am concerned that the Date toString method used in this approach will not produce correct sort semantics.
I am open to discussion on this issue, as I am as always not 100% familiar with DN code. I have attempted to discuss via the forums, without success. Hence going ahead and attempting to make the changes myself.