import pyodbc
import pandas as pd
from datetime import datetime
# datetime object containing current date and time
now = datetime.now()
cnxn = pyodbc.connect(driver='{SQL Server}',server='DBServerName',database='DB',trusted_connection='yes')
cursor = cnxn.cursor()
sql = "EXEC sp_who2"
data = pd.read_sql(sql,cnxn)
data[13]=now
print(data)