Problem Note 4072: Oracle date format improperly applied when inserting/updating with
SAS/ACCESS Interface to Oracle
When using SAS/ACCESS Interface to Oracle for inserting or updating
date values in an Oracle table, unexpected results might be received for
inserted date values.
By default, SAS uses the DDMONYYY:HH24:MI:SS Oracle format when
performing inserts or updates of date values to an Oracle table. This
formatting will present a problem if the value to be inserted is a date
rather than a datetime.
Currently, the only way to circumvent this problem is to use the
SASDATEFMT data set option to specify a different format. Although this
option will correct the problem, it can be tedious to specify the option
for each file being accessed.
As an alternative, an updated module can be downloaded that will allow
you to set a global SASDATEFMT environment variable. You can download
the update from
http://ftp.sas.com/techsup/download/pc/V81oracle_date.zip
Please reference the readme file contained in the download for
important information about setting the environment variable.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to Oracle | Microsoft Windows NT Workstation | 8 TS M0 | 8.2 TS2M0 |
| Microsoft Windows 95/98 | 8 TS M0 | 8.2 TS2M0 |
*
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 |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> Oracle
SAS Reference ==> LIBNAME Engines
|
| Date Modified: | 2001-06-28 13:57:55 |
| Date Created: | 2001-01-09 14:47:57 |
