Problem Note 32280: The JDBC driver in SAS® software returns the wrong date and time values for the GMT time zone
 |  |  |  |  |
The date and time returned by the SAS JDBC driver is incorrect when the time zone is set to GMT. The date returned is one hour earlier than the correct date. For example, if the date and time is midnight on 1 June 08, the time returned would be 11:00 p.m. 31 May 08.
The date and time discrepancy can occur in user-written Java programs that use the SAS JDBC driver when the client program is running on a machine set to the GMT time zone. It can also occur in SAS® Web Report Studio when Graphs have a time axis, and the server is hosted on a machine set to GMT.
Select the Hot Fix tab in this note to access the hot fix for this issue.
Until you install the hot fix, a viable workaround is to change the time zone of the machine to GMT+1. The downside of making this change is that all other applications on that machine will then use a time and date that is shifted by one hour.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS Integration Technologies | z/OS | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft® Windows® for x64 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows 2000 Server | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows 2000 Professional | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows NT Workstation | 9.1 TS1M3 SP4 | |||
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows XP Professional | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Windows Vista | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| 64-bit Enabled Solaris | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| HP-UX IPF | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Linux | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Linux on Itanium | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| OpenVMS Alpha | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Tru64 UNIX | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
A fix for this issue for SAS Web Report Viewer 3.1 is available at:
http://www.sas.com/techsup/download/hotfix/wrv31.html#032280A fix for this issue for SAS Web Report Studio 3.1 is available at:
http://www.sas.com/techsup/download/hotfix/wrs31.html#032280A fix for this issue for SAS JDBC Drivers 9.1.3 is available at:
http://www.sas.com/techsup/download/hotfix/jdbc913.html#032280| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2008-06-06 08:54:28 |
| Date Created: | 2008-05-30 09:43:43 |