Specifies how the driver describes the data type for Date/Time/Timestamp input parameters.
This property only applies to connections to Azure and SQL Server 2008 and higher. For prior versions of Microsoft SQL Server, the driver always describes Date/Time/Timestamp input parameters as datetime.
Valid values
auto | dateTime | dateTimeOffset
Behavior
If set to auto, the driver uses the following rules to describe the data type of Date/Time/Timestamp input parameters:
If an input parameter is set using setDate(), the driver describes it as date.
If an input parameter is set using setTime(), the driver describes it as time.
If an input parameter is set using setTimestamp(), the driver describes it as datetimeoffset.
If set to dateTime, the driver describes Date/Time/Timestamp input parameters as datetime.
If set to dateTimeOffset, the driver describes Date/Time/Timestamp input parameters as datetimeoffset.
If an input parameter is set using setDate(), the driver describes it as date.