1,126
edits
Difference between revisions of "Date and Time formats in Content Manager OnDemand"
Date and Time formats in Content Manager OnDemand (view source)
Revision as of 15:14, 18 January 2018
, 15:14, 18 January 2018Corrected some typos and added a link to an IBM CMOD knowledgebase article on the old & new date formats.
(Added sections in IBM CMOD Dates SQL and IBM CMOD dates Excel.) |
m (Corrected some typos and added a link to an IBM CMOD knowledgebase article on the old & new date formats.) |
||
| Line 6: | Line 6: | ||
== History == | == History == | ||
In the early 1990's when IBM CMOD was developed, two facts necessitated the IBM Content Manager OnDemand developers to use their own date formats: The high cost of data storage, and the lack of built-in date/time formats in the database engines that were supported by OnDemand. The solution was to store dates as integers - representing the number of days since midnight, January 1st, 1970, UTC, and times as the number of seconds since the same date. If you're a UNIX or Linux user, you should recognize this date as the 'epoch' date, used as their internal representation for dates for most operating system functions. In fact, IBM CMOD used UNIX epoch as its internal date-and-time format up until IBM CMOD v9. | In the early 1990's when IBM CMOD was developed, two facts necessitated the IBM Content Manager OnDemand developers to use their own date formats: The high cost of data storage, and the lack of built-in date/time formats in the database engines that were supported by OnDemand. The solution was to store dates as integers - representing the number of days since midnight, January 1st, 1970, UTC, and times as the number of seconds since the same date. If you're a UNIX or Linux user, you should recognize this date as the 'epoch' date, used as their internal representation for dates for most operating system functions. In fact, IBM CMOD used UNIX epoch as its internal date-and-time format up until IBM CMOD v9.0. | ||
This relationship means you can fairly easily convert between UNIX epoch date/time format, and the IBM CMOD arsdate format - simply divide by 86400 -- the number of seconds in a day. | This relationship means you can fairly easily convert between UNIX epoch date/time format, and the IBM CMOD arsdate format - simply divide by 86400 -- the number of seconds in a day. | ||
| Line 108: | Line 108: | ||
[https://www.ibm.com/support/knowledgecenter/SSEPCD_10.1.0/com.ibm.ondemand.administeringmp.doc/dodda004.htm IBM CMOD Knowledgebase: arsdate examples] | [https://www.ibm.com/support/knowledgecenter/SSEPCD_10.1.0/com.ibm.ondemand.administeringmp.doc/dodda004.htm IBM CMOD Knowledgebase: arsdate examples] | ||
[https://www-01.ibm.com/support/docview.wss?uid=swg27036188 Old & New IBM CMOD date formats] | |||