Published on InterSystems Developer Community (https://community.intersystems.com)

Home > Any implications of changing the type of a property of a persistent class from Timestamp to String?

Question
Duncan Priest · Aug 4, 2021

Any implications of changing the type of a property of a persistent class from Timestamp to String?

In a typical database, changing the type of a column from some kind of date/time to a string would require a degree of migration effort for existing values. In Caché, my suspicion is that this is not the case, and I could simply change a property definition from %Timestamp to %String (MAXLEN = "30") and recompile, without needing to worry about damaging the existing data stored for this property. Is this correct? Or would I find the existing data in this property being lost or corrupted?

Thanks in anticipation

#Databases #Caché
Product version: Caché 2018.1

Source URL:https://community.intersystems.com/post/any-implications-changing-type-property-persistent-class-timestamp-string