-1

I'm trying to compare a variable to query results in the following which are dates in yyyymmdd format. The database field LastUpdate is of type int.

When I test this, I think I am getting the false result because the query is a tuple compared to my variable as int.

Is there a way to convert the (20160422,) to an int?

import pymssql

conn = pymssql.connect(server='', user='', password='', database='')

cur = conn.cursor()
cur.execute('SELECT Top 1 LastUpdate FROM tbl_Date')

myDate = 20160422

for row in cur:
    print(row)

    if row == myDate:
        print('true')
        #then do something
    else:
        print('false')

conn.close()
bassmann
  • 250
  • 3
  • 18

1 Answers1

1

As your suggestion, I've got this working based as follows; I just wasn't sure how to access elements of an array in Python, I just needed a clue. Thanks again.

import pymssql

conn = pymssql.connect(server='', user='', password='', database='')

cur = conn.cursor()
cur.execute('SELECT Top 1 LastUpdate FROM tbl_Date')

myDate = 20160426

for row in cur:
    print(row[0])

if row[0] == myDate:
    print('true')
    #then do something
else:
    print('false')

conn.close()
bassmann
  • 250
  • 3
  • 18