Inserting DATETIME value in SQL Server using python

Question

I have the below query that Python uses to insert values into database.

INSERT INTO Shift_Info (Login_Date,Machine_Number,Item_Number,Job_Number,Operator,Shift,LogOff_Date,Good_Parts,Total_Run_Time,Effective_Run_Time,Run_Through) 
VALUES (2020-03-16 15:42:21,'CX07',310164,5165877,21952,1,2020-03-16 15:51:06,89,525,525,12)

But get the below error on the first entry of time value at '15'. Whats the issue and any solution other than reformatting inputs?

pypyodbc.ProgrammingError: ('42000', "[42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '15'.")

Use parameter placeholders: stackoverflow.com/a/9521382/42346 — mechanical_meat
– mechanical_meat, Commented Apr 16, 2020 at 22:25

Dale K · Accepted Answer · 2020-04-16 22:41:09Z

2

After reading the docs on transact-sql https://learn.microsoft.com/en-us/sql/t-sql/data-types/datetime-transact-sql?view=sql-server-ver15

I just need to enclose in quotes to allow SQL Server to parse the string.

INSERT INTO Shift_Info (Login_Date,Machine_Number,Item_Number,Job_Number,Operator,Shift,LogOff_Date,Good_Parts,Total_Run_Time,Effective_Run_Time,Run_Through) 
VALUES ('2020-03-16 15:42:21','CX07',310164,5165877,21952,1,'2020-03-16 15:51:06',89,525,525,12)

edited Apr 16, 2020 at 22:41

Dale K

28.1k15 gold badges59 silver badges85 bronze badges

answered Apr 16, 2020 at 22:39

Dylan Devotta

858 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Inserting DATETIME value in SQL Server using python

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related