str timestamp to mysql timestamp in python

Question

I am trying to store unix timestamp in mysql with mysql timestamp but when I try to do that it shows 0000-00-00 00:00:00 in mysql

the way I have tried are as follows

table structure in mysql id name timestamp whare id is auto name is varchar and timestamp is timestamp

sql query is "INSERT INTO stocks (ticker, timestamp) VALUES ("harry", "1607485826")"

I have tried another one with datetime as follows from datetime import datetime // imported once only

tmpstp = datetime.fromtimestamp(1607485826)
f'INSERT INTO stocks (ticker, timestamp) VALUES ("harry", {tmpstp})'

Akina · Accepted Answer · 2020-12-09 05:08:47Z

1

Use

INSERT INTO stocks (ticker, `timestamp`) 
VALUES (@ticker, FROM_UNIXTIME(@timestamp))

where @ticker and @timestamp are parameters placeholders.

For shown parameters values the query will be

INSERT INTO stocks (ticker, `timestamp`) 
VALUES ('harry', FROM_UNIXTIME(1607485826))

PS. I recommend you to rename the column timestamp strongly - this is reserved word in MySQL.

answered Dec 9, 2020 at 5:08

Akina

43.2k6 gold badges17 silver badges30 bronze badges

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

2 Comments

thank you so much @Akina you helped me a lot

sir could you please tell me what if I want to use it in python as it is not working through python