0

User choose the QDateTime and I need to write query in pyodbc which selects items in table which date are greater than choosen date. How to convert it in sql datetime? And how to write this request?

Foo Boy
  • 9
  • 4
  • Did my answer help you? I noticed that none of your previous questions have been marked with an answer. If you see an answer that has helped you, you can put closure to your question by marking it as accepted. I'd encourage you do that with your previous questions that have been answered. – zedfoxus May 25 '20 at 21:52
  • 1
    @zedfoxus Ok, thanks – Foo Boy May 28 '20 at 19:54

1 Answers1

0

You can convert QDateTime variable (e.g. starttime) to a formatted string using something like this:

starttime.toString("YYYY-mm-dd");

Pass this to Python.

To convert that to python's native datetime, do this:

import datetime
starttime = datetime.datetime.strptime(data_you_got_from_QDateTime, '%Y-%m-%d')

That'll give you a Python datetime.datetime object to work with.

If you just want to use the data provided by QDateTime in a SQL query, you could do this:

import pyodbc

yourdate = date_received_from_QDateTime

cn = pyodbc.connect('DRIVER={SQL Server};SERVER=SQLSRV01;DATABASE=DATABASE;UID=USER;PWD=PASSWORD')
cursor = cn.cursor()

cursor.execute("select * from yourtable where yourfield > ?", yourdate)
for row in cursor.fetchall():
    print row

That should give you reasonable information to tweak the codes above to get you the information. Since I am not aware how you are sending QDateTime to Python, I cannot comment on it.

zedfoxus
  • 35,121
  • 5
  • 64
  • 63