Difference between revisions of "Date and Time formats in Content Manager OnDemand"

The new date/time formats introduced in IBM CMOD v9.5 use the native date/time fields in your chosen database engine.  This greatly simplifies date & time calculations and queries, as the database can use highly optimized search functions to complete user requests.  Unfortunately, OnDemand Application Group data will need to be migrated to use these new date formats, which is best done at the time of an upgrade or data migration.  Another improvement is that native database date formats support a MUCH wider range of dates.  Prior to IBM CMOD v9.5, the range of dates that could be stored in CMOD were from 1970 until 2070 for date fields, and from 1970 to 2038 for date/time fields.  Most native database date/time fields not only support years from 0000 to 9999, they also have accuracy down to a millionth of a second.