Error using %s for String Formatting in MySQL Query with Python

Question

The following line is from a query that I keep getting an error on. When I change the %s to 00 it works just fine. How do I keep the formatting to have the actual seconds:

from_unixtime(el.DeviceTimeStamp/1000, '%Y-%m-%d %H:%i:%s') as 'Entry_Timestamp'```

How are you executing this? %s is a placeholder value for the Python driver. — tadman
– tadman, Commented May 13, 2019 at 16:44

ScaisEdge · Accepted Answer · 2019-05-13 16:43:36Z

2

I'm not in python but%s is used for passing param so Try escaping the % using %%

  from_unixtime(el.DeviceTimeStamp/1000, '%%Y-%%m-%%d %%H:%%i:%%s') as 'Entry_Timestamp'```

or

  from_unixtime(el.DeviceTimeStamp/1000, '%Y-%m-%d %H:%i:%%s') as 'Entry_Timestamp'```

answered May 13, 2019 at 16:43

ScaisEdge

134k10 gold badges98 silver badges111 bronze badges

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

Comments

Eric Shreve · Accepted Answer · 2019-05-13 16:48:02Z

0

On a complete lark I changed '%s' to be '%S' in my query and now it works fine.

answered May 13, 2019 at 16:48

Eric Shreve

1392 silver badges10 bronze badges

Collectives™ on Stack Overflow

Error using %s for String Formatting in MySQL Query with Python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related