Python Forum
[PyQt] to display cotent of database between two dates
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[PyQt] to display cotent of database between two dates
#10
Put this in a little MUC (Minimal Usable Code) and run it and then you tell me why the 2nd one does not work ;-)
start_date ='01-12-2019'             
end_date = '28-12-2019'

MySQL_1 = "SELECT * FROM correction_loc35R  where  date_correction between '01-12-2019' AND '28-12-2019' ORDER BY date_correction DESC"
MySQL_2 = "SELECT * FROM correction_loc35R  where  date_correction between start_date AND end_date ORDER BY date_correction DESC"

print(MySQL_1)
print(MySQL_2)
Reply


Messages In This Thread
RE: to display cotent of database between two dates - by Denni - Dec-31-2019, 09:51 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Display and update the label text which display the serial value jenkins43 5 8,992 Feb-04-2019, 04:36 AM
Last Post: Larz60+
  Display more than one button in GUI to display MPU6000 Sensor readings barry76 4 3,835 Jan-05-2019, 01:48 PM
Last Post: wuf

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020