I'm recently used the SQL Data Generator (version 22.214.171.1242) to generate test data for one of my applications. In the process, I encountered an issue where a date value generated by the Data Generator was an invalid date. The date value generated was Apr 4, 1992, 2:53 AM EST, which according to the daylight savings is invalid (since the clock jumped from 2:00 to 3:00.
The SQL Server DB allowed this invalid date value to be created and the JDBC driver did not throw an exception when the value was retrieved from the DB. Instead, the JDBC driver auto-corrected the date value, incrementing the hour value by one hour to insure it's a valid date. Management Studio showed the time as 2:53 while my app showed the time as 3:53 after the value was retrieved through the JDBC driver.