Usage Note 19798: Incorrect Date values inserted during data type conversion with MYSQL
Using SAS/ACCESS to MYSQL to insert an invalid timestamp and year value
will result in incorrect data being inserted.
Inserting an invalid timestamp will insert NULLS because the conversion
can't be done. If an invalid year value is inserted the conversion can
be done, but the incorrect value is inserted.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to MySQL | Microsoft Windows 2000 Professional | 9.1 TS1M2 | |
| Microsoft Windows XP Professional | 9.1 TS1M2 | |
| Microsoft Windows 2000 Server | 9.1 TS1M2 | |
| 64-bit Enabled Solaris | 9.1 TS1M2 | |
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M2 | |
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M2 | |
| HP-UX IPF | 9.1 TS1M2 | |
*
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.
| Date Modified: | 2008-03-06 14:06:13 |
| Date Created: | 2007-03-21 11:22:57 |
