Toad When using Save As XLS to export and the date is 1/1/1900 or 1/2/1900 then the date exported into Excel will increment by 1 day.
Steps to reproduce the issue: 1. Add or modify the date to any table to be 1/1/1900 or 1/2/1900. 2. Save As XLS File. 3. Open the Excel file and you will see the date of 1/1/1900 as 1/2/1900 and 1/2/1900 as 1/3/1900.
解决办法
Use Save As XLS Instance to export into Excel.
This is a documented Microsoft Bug. Microsoft assumes that the year 1900 is a leap year. For more information about this bug please go to the following link: http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q181/3/70.asp&NoWebContent=1
