1,126
edits
Difference between revisions of "Date and Time formats in Content Manager OnDemand"
Jump to navigation
Jump to search
m
Date and Time formats in Content Manager OnDemand (view source)
Revision as of 22:37, 9 March 2020
, 22:37, 9 March 2020Added a section on CMOD database queries using database native date formats, and the year function.
m (Simplified DB2 SQL date functions for IBM CMOD dates) |
m (Added a section on CMOD database queries using database native date formats, and the year function.) |
||
| Line 70: | Line 70: | ||
date('1970-01-01') + RPT_DATE days | date('1970-01-01') + RPT_DATE days | ||
If your CMOD Application Group is configured to use the new date formats (with their underlying database-native date fields) then you can use built-in database functions to assist with your SQL queries: | |||
select cust_num,count(*) from ABC4 where year(rpt_date) >= 2020 group by cust_num | |||
This query would show you a list of customer numbers, and the number of times they appear, in the database table called 'ABC4' where the date is the year 2020 or greater. | |||
== IBM CMOD Dates in Excel == | == IBM CMOD Dates in Excel == | ||