Python Parameters Sent to the Database
The following table explains how Python objects passed to Cursor.execute() as parameters are formatted and sent to the driver/database.

Note on Description Column:

The "Description" column in the table is intended to provide a generic label for the type, and does not always reflect the exact SQL Server data type name. Please refer to the SQL Server column type for precise behavior and compatibility.

Note on SQL Server's timestamp and rowversion types

• In SQL Server, thetimestamp type is a deprecated alias forrowversion, which is a binary type (binary(8)) used for version-stamping table rows.It does not represent a date or time value.
• The mapping table above may refer to "timestamp" as a generic type label, but this shouldnot be confused with SQL Server'stimestamp/rowversion type.
• At this time,rowversion/timestamp columns are not mapped to Python'sdatetime.datetime type; they should be treated as unsupported or as binary data.
• For actual date/time values, use SQL Server types such asdatetime,datetime2,smalldatetime, ordate.

Caution

If you need to use SQL Server'srowversion/timestamp, handle these columns as binary data in your Python code. They do not carry any date or time information.

SQL Values Received from the Database
The following table describes how database results are converted to Python objects.