Date, Time, Datetime, and Smalldatetime Datatypes

SAP jConnect for JDBC supports date, time, datetime, and smalldatetime.

If you select from a table that contains a date or time column, and you have not enabled date/time support in SAP jConnect (by setting the version), the server tries to convert the date or time to a datetime value before returning it.

This might cause problems if the date to be returned is earlier than 1/1/1753. In that case, a conversion error occurs, and the database informs you of the error.
SAP SQL Anywhere supports a date and time datatype, but they are not yet directly compatible with those in SAP Adaptive Server version 12.5.1 and later. Using SAP jConnect, continue to use the datetime and smalldatetime datatypes when communicating with SAP SQL Anywhere.
The maximum value in a datetime column in SAP SQL Anywhere is 1-1-7911 00:00:00.
Using SAP jConnect, you receive conversion errors if you attempt to insert dates earlier than 1/1/1753 into datetime columns or parameters.
Refer to the SAP Adaptive Server manuals for more information on the date and time datatypes; of special note is the information about on allowable implicit conversions.
If you use getObject with an SAP Adaptive Server date, time, or datetime column, the value returned is, respectively, a java.sql.Date, java.sql.Time, or java.sql.Timestamp datatype.