wrong string to timestamp conversion in python

Question

I tried to convert the string "01/03/2019 0:10:00" to a timestamp and the result I got was 1551395400 which is incorrect. This timestamp is equivalent to 28/02/2019 11:00:00.

I don´t understand why I am getting this issue, yesterday on the same computer the conversion was correct.

The code:

date ="01/03/2019 0:10:00"
time.mktime(datetime.datetime.strptime(date, "%d/%m/%Y %H:%M:%S).timetuple())

When I run that code the output I get is 1551399000.0 which comes back as the correct time. Sounds like you might not be considering timezones? — greg_data
– greg_data, Commented Jul 26, 2019 at 15:04
Did your local time zone change, or did you change some setting on your computer related to time zones? — John Gordon
– John Gordon, Commented Jul 26, 2019 at 15:08
I realize when i insert data in a database and I get an error of unique constraint — Kike .Asekas
– Kike .Asekas, Commented Jul 26, 2019 at 15:10
You example has a missing double quote, so it can't be exactly what you ran. It might be informative to get a screen capture of exactly what you are running and the output. Here's mine (which differs from greg_data by 5 hours because of timezone differences). >>> date ="01/03/2019 0:10:00" >>> time.mktime(datetime.datetime.strptime(date, "%d/%m/%Y %H:%M:%S").timetuple()) 1551417000.0 — Malcolm
– Malcolm, Commented Jul 26, 2019 at 15:21

user11553043 · Accepted Answer · 2019-07-26 15:05:01Z

1

The hour has one zero, but is described as %H?

answered Jul 26, 2019 at 15:05

user11553043

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

1 Comment

John Gordon Over a year ago

Changing it to 00: has no effect, so I don't think this is the cause.

Alex_6 · Accepted Answer · 2019-07-26 15:34:37Z

1

I think you have a timezone problem. Try this :

import pytz, datetime
local = pytz.timezone ("Europe/Paris") # Put your timezone
date ="01/03/2019 0:10:00"
dt = datetime.datetime.strptime(date, "%d/%m/%Y %H:%M:%S")
local_dt = local.localize(dt, is_dst=None)
utc_dt = local_dt.astimezone(pytz.utc)

Then you can call :

datetime.datetime.timestamp(utc_dt)

answered Jul 26, 2019 at 15:34

Alex_6

3191 gold badge4 silver badges16 bronze badges

3 Comments

Kike .Asekas Over a year ago

So is. Thank you very much.

Kike .Asekas Over a year ago

But now I have another problem. python says that datetime.datetime has no attribute timestamp

Alex_6 Over a year ago

Well it's weird. Make sure you've successfully imported the datetime module. Check this website out : programiz.com/python-programming/datetime/timestamp-datetime for some information on the conversion of a datetime object to a timestamp.

Collectives™ on Stack Overflow

wrong string to timestamp conversion in python

2 Answers 2

1 Comment

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related