1. Install the pymssql package.
pip install pymssql
2. Create the your .py file.
test_mssql.py
import pymssql
conn = pymssql.connect(host='<host>', user='<username>', password='<password>', database='<dbname>')
cur = conn.cursor()
cur.execute('SELECT CONVERT(date, CURRENT_TIMESTAMP)')
row = cur.fetchone()
while row:
print "CURRENT_TIMESTAMP=%s" % (row[0])
row = cur.fetchone()
conn.close()
3. Run it.
python test_mssql.py
4. It should return you today’s date.
CURRENT_TIMESTAMP=2014-07-11
Done =)
Reference: pymssql
Eureka! 