python - Retrieving SQL Server data using pyodbc is returning unexpected data values

Question

I am learning Python and have written some code to retrieve data from a SQL Server table. The code is as follows:

import pyodbc

connection = pyodbc.connect("Driver={SQL Server Native Client 11.0};"
"Server=xxx"
"Database=xxx"
"uid=xxx"
"pwd=xxx"
)

cursor = connection.cursor()
cursor.execute('SELECT * FROM Dealers')

for row in cursor:
print(list(row))

This code works fine but the output, for some data types isn't what I expected. For example, I have a line of output that looks like this:

Decimal('0.000'), Decimal('83.360'), True, True, Decimal('0.000'), datetime.date(2017, 5, 31), True, 1, True, True, datetime.datetime(2017, 5, 31, 18, 28, 57, 686666)

Instead of something like Decimal('83.360'), how do I simply get 83.360? Same for the date/time values?

Answer 1

Decimal('83.360') and datetime.date(2017, 5, 31) are the default representations (repr()) of a Decimal object and a datetime.date object. If you want "just 83.360 and 2017-05-31" then you can call str() on them (as opposed to repr()) and you will get a string representation of the value. Note however that

x = str(Decimal('83.360'))

will result in x being a str, i.e., it will have lost its number-ness, so

y = x + 1

results in an error ('TypeError: can only concatenate str (not "int") to str'), not 84.360.