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 19:20, 22 March 2018
, 19:20, 22 March 2018Simplified DB2 SQL date functions for IBM CMOD dates
m (Added section on IBM CMOD timestamp conversion in Excel.) |
m (Simplified DB2 SQL date functions for IBM CMOD dates) |
||
| Line 65: | Line 65: | ||
You can use this function to get a date from a timestamp field: | You can use this function to get a date from a timestamp field: | ||
date | date('1970-01-01') + RPT_TIMESTAMP SECONDS | ||
And this function to get a date from a date field: | And this function to get a date from a date field: | ||
date | date('1970-01-01') + RPT_DATE days | ||
== IBM CMOD Dates in Excel == | == IBM CMOD Dates in Excel == | ||