SAS Support Site Home | Samples and SAS Notes Home
SAS Notes V6-QUERY-E299
Dates displayed in the LOOKUP DISTINCT window may have incorrect century


When dates for the DB2, DB2/2, DB2/6000, ODBC and SYBASE access modes are displayed in the LOOKUP DISTINCT VALUES feature of the SQL Query Window, all dates in the year 2000 or above will be displayed with a 20th century date. For example, the DB2 date 2001-04-01 will be displayed as 1901-04-01.

Also, all dates for the ORACLE access mode will be displayed with a two-digit year. The problem is corrected in Release 6.08 TSLEVEL 430, Release 6.09E TSLEVEL 460, Release 6.11 TSLEVEL 051, and Release 6.12 TSLEVEL 060.

THIS IS A YEAR 2000 READINESS DISCLOSURE.


Products: BASE
Component: QUERY
Priority: HIGH
Status: Outstanding Problem
Date: Wed, 7 Jul 1999

System Release Reported Release Fixed
VM/ESA (CMS) 6.09 TS450 6.09 TS470  
OS/390 (MVS) 6.09 TS450 6.09 TS470  
OpenVMS VAX 6.09 TS450 6.09 TS470  
AIX/6000 6.12 TS020 6.12 TS060  
HP-UX Operating Systems 6.12 TS020 6.12 TS060  
IBM OS/2 6.12 TS020 6.12 TS060  
Solaris 6.12 TS020 6.12 TS060  
OpenVMS Alpha 6.12 TS020 6.12 TS060  
Windows 3.11 6.12 TS020 6.12 TS060  
Windows NT 6.12 TS020 6.12 TS060  
Windows 95 6.12 TS020 6.12 TS060  
Compaq Tru64 Unix 6.12 TS040 6.12 TS051  
Macintosh 6.12 TS040 6.12 TS051  
AIX/6000 6.11 TS020 6.12 TS060  
HP-UX Operating Systems 6.11 TS020 6.12 TS060  
IBM OS/2 6.11 TS020 6.12 TS060  
Solaris 6.11 TS020 6.12 TS060  
Windows 3.11 6.11 TS020 6.12 TS060  
Intel ABI 6.11 TS040 6.11 TS051  
Silicon Graphics Unix 6.11 TS040 6.11 TS051  
Compaq Tru64 Unix 6.11 TS040 6.12 TS051  
Windows NT 6.11 TS040 6.12 TS060  
Windows 95 6.11 TS040 6.12 TS060  
Intel ABI 6.10 TS018 6.11 TS051  
Silicon Graphics Unix 6.10 TS018 6.11 TS051  
Macintosh 6.10 TS037 6.12 TS051  
Compaq Tru64 Unix 6.10 TS018 6.12 TS051  
IBM OS/2 6.10 TS019 6.12 TS060  
Windows 3.11 6.10 TS019 6.12 TS060  
VM/ESA (CMS) 6.08 TS408 6.09 TS470  
OS/390 (MVS) 6.08 TS408 6.09 TS470  
IBM OS/2 6.08 TS408 6.12 TS060  
OpenVMS VAX 6.08 TS408 6.09 TS470  
VSE/ESA (VSE) 6.08 TS408 6.08 TS440  
Windows 3.11 6.08 TS408 6.12 TS060  
AIX/6000 6.09 TS037 6.12 TS060  
HP-UX Operating Systems 6.09 TS037 6.12 TS060  
Solaris 6.09 TS037 6.12 TS060  
DEC Ultrix 6.09 TS037  
OpenVMS Alpha 6.09 TS037 6.12 TS060  
Windows NT 6.09 TS037 6.12 TS060  

No Fixes Available