SQL Date Variables in Python

2024/10/5 15:06:34

I am writing a query inside a Python script.The query is as follows:

cur = conn.cursor()
query1 = """select max(date_time) from tablename"""
cur.execute(queryy1)
conn.commit()
rows = cur.fetchall()
print rows

Until here the code works fine and gives me the date in some format of the kind datetime.datetime[...] Now,I want to use this variable 'rows' in another sql query,say,of the following kind:

query2="""insert into table xyz(select * from abc where date_time = '%s')"""%(rows)
cur.execute(query2)

This gives me an error which is as follows:

DataError:invalid input syntax for type timestamp : "[((datetime.datetime(2014,6,6,23,0),)]"    

I am totally new to learning Python. Any help would be appreciated.

I tried the following and it worked:

query2 ="""insert into table xyz(select * from abc where date_time = %s)"""
cur.execute(query2,(rows))
Answer

I tried this and now it worked

query2 ="""insert into table xyz(select * from abc where date_time = %s)"""
cur.execute(query2,(rows))

Though, I don't know why it worked and how is it different from what I was trying earlier

https://en.xdnf.cn/q/120258.html

Related Q&A

Truble to create a matrix for sudoku in python

I have to make a sudoku template, so I need to get random numbers into the matrix, but they can not be repeated in the rows or columns, but I can not do it. For this I can not use numpy. In this case I…

Password validation in python with regex without duplicate chars

The parameter is a string. Check whether it forms a secure password.A password is safe ifthere is at least a lowercase letter in it, and there is at least one capital letter in it, and there is at leas…

Processing non-english text

I have a python file that reads a file given by the user, processes it, and ask questions in flash card format. The program works fine with an english txt file but I encounter errors when trying to pro…

Downloading all zip files from url

I need to download all the zip files from the url: https://www.ercot.com

sql to query set

I have 2 tables:puzz_meeting_candidats :- id, canceled, candidat_id, meeting_id puzz_meeting :- id, ClientI have a query follow: SELECT U1.`candidat_id` AS Col1 FROM `puzz_meeting_candidats` U1 INN…

Google App Engine, best practice to schedule code execution [closed]

Closed. This question is opinion-based. It is not currently accepting answers.Want to improve this question? Update the question so it can be answered with facts and citations by editing this post.Clo…

delete rows by date and add file name column for multiple csv

I have multiple "," delimited csv files with recorded water pipe pressure sensor data, already sorted by date older-newer. For all original files, the first column always contains dates forma…

X = Y = Lists vs Numbers [duplicate]

This question already has answers here:Immutable vs Mutable types(20 answers)How do I clone a list so that it doesnt change unexpectedly after assignment?(24 answers)Closed 4 years ago.In python : I h…

Python data text file grades program

Looking for help with my program. There is a text file with 5 first and last names and a number grade corresponding to each person. The task is to create a user name and change the number grade to a le…

how to fill NA with mean only for 2 or less consequective values of NA

I am new to python. please help me how I should proceed. The following dataframe contains large blocks of NaNs. # Fill the NAs with mean only for 2 or less consecutive values of NAs. # Refer to the d…