Purpose

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.

Data source method

public String getDateTimeInputParameterType()

public void setDateTimeInputParameterType(String)

Default

auto

Data type

String

See also

Connection property descriptions