skip to main content
Connection property descriptions : DateTimeOutputParameterType
  

Try DataDirect Drivers Now

DateTimeOutputParameterType

Purpose

Specifies how the driver describes the data type for Date/Time/Timestamp output parameters.
This property only applies to connections to Microsoft SQL Server 2008 and higher and Microsoft Windows Azure SQL Database. For connections to prior versions of Microsoft SQL Server, the driver always describes Date/Time/Timestamp output 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 output parameters:
*If an output parameter is set using setDate(), the driver describes it as date.
*If an output parameter is set using setTime(), the driver describes it as time.
*If an output parameter is set using setTimestamp(), the driver describes it as datetimeoffset.
If set to dateTime, the driver describes Date/Time/Timestamp output parameters as datetime.
If set to dateTimeOffset, the driver describes Date/Time/Timestamp output parameters as datetimeoffset.

Data source method

setDateTimeOutputParameterType

Default

auto

Data type

String

See also

Data type handling properties