Problem Note 10723: Support for Teradata date handling where dates are stored as integers
The SAS Campaign Management component does not currently support date
values that are stored as type INTEGER in the Teradata database.
A Technical Support hot fix for this issue is available at:
http://ftp.sas.com/techsup/download/hotfix/cam75.html
By applying this hotfix, you enable support for Teradata dates stored
as integers. This support is provided via a new ISMCONFIG option,
DBDateFormat, which has two possible values:
INTEGER_DATE_YYYMMDD where YYY is the year number starting at 1900
(so 2003 become 103), MM is the month digit field
01 to 12, and DD is the day digit field 01 to 31.
INTEGER_DATE_YYYYMMDD where YYYY is the year number, say 2003, MM
is the month digit field 01 to 12, and DD is the
day digit field 01 to 31.
Operating System and Release Information
| SAS System | SAS Campaign Management | Microsoft Windows NT Workstation | 7.4 | | | |
| Microsoft Windows XP Professional | 7.4 | | | |
| Microsoft Windows 2000 Professional | 7.4 | | | |
| Microsoft Windows 2000 Advanced Server | 7.4 | | | |
| Microsoft Windows 2000 Server | 7.4 | | | |
| Microsoft Windows 2000 Datacenter Server | 7.4 | | | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2003-09-15 10:53:41 |
| Date Created: | 2003-08-22 11:11:24 |
