time data conversion missing microseconds in gm time python

Question

I am converting some date time, but I got a problem. the date time is

my_time = "2012-03-18 14:50:36.90"

my code to convert this date time is

import time
import datetime
import calendar

time_con = datetime.datetime.strptime(my_time,'%Y-%m-%d %H:%M:%S.%f')
final_time = calendar.timegm(time_con.timetuple())

when print, i got

>> print "time_con", time_con

datetime.datetime(2012, 3, 18, 14, 50, 36, 900000)

when I print final_time , I got

>> print "final_time", final_time
1332082236

I am unable to get milliseconds, and I don,t know how to deal with them properly because I need those milliseconds in my date time. I search SO but no clue. but in Can help would be great and it will save my day. thanks

@linusg I change variable name. thanx a lot , but problem still exists. — roy, Jan 25 '17 at 16:15
@linusg I hope now its fine. thanx for the pointing my mistakes. — roy, Jan 25 '17 at 16:17
Look, this will never ever run and therefore not work. `final-time` has ... a dash in it (see http://stackoverflow.com/questions/2064329/why-python-does-not-allow-hyphens if still don't believe) — linusg, Jan 25 '17 at 16:21
@linusg thanx . I got the point. Actually I changed the names of variables, therefore I make mistakes. but I learn now and i make corrections accordingly. — roy, Jan 25 '17 at 16:26
See my answer below, which is different from ForceBru and shows it is indeed possible. — linusg, Jan 25 '17 at 16:39

linusg · Accepted Answer · 2017-01-25T17:27:36.777

2

This is easy to solve. Since you have not the milliseconds but microseconds stored in time_con, we can do time_con.microsecond*1000 to get milliseconds.

import time
import datetime
import calendar

my_time = "2012-03-18 14:50:36.90"
time_con = datetime.datetime.strptime(my_time,'%Y-%m-%d %H:%M:%S.%f')
microsecs =  time_con.microsecond
final_time = calendar.timegm(time_con.timetuple())*1000000 + millisecs
# final_time is in microseconds

# To print in seconds
# print(final_time/1000000)

print(final_time)

Results in

1332082236900

Which is hopefully what you want. Hope this helps!

edited Jan 25 '17 at 17:27

answered Jan 25 '17 at 16:38

linusg

6,289
4
28
78

i will implement and will come back in a moment. thanx alott – roy Jan 25 '17 at 16:46
thanx a lot for the help. its my extremely silly mistake. %f mean micro. so I was talking about microseconds. can you change it accordingly so that I accept your answer. because your solutions works perfectly fine for milliseconds. – roy Jan 25 '17 at 17:04
thanx a lot for the help and precious time. – roy Jan 25 '17 at 17:06
thanx , i will come back in a moment. – roy Jan 25 '17 at 17:23
@ i accept your answer because it works fine. thanx a lot for the help. – roy Jan 25 '17 at 17:28
Sorry, there was a typo in the last print, fixed now, so give it a try ;) – linusg Jan 25 '17 at 17:28
No Problem, glad I could help! Happy coding :D – linusg Jan 25 '17 at 17:30

score 1 · Answer 2 · answered Jan 25 '17 at 17:03

1

In Python 3 you can do

import datetime

my_time = "2012-03-18 14:50:36.90"
time_con = datetime.datetime.strptime(my_time,'%Y-%m-%d %H:%M:%S.%f')
final_time = time_con.replace(tzinfo=datetime.timezone.utc).timestamp()
# 1332082236.9

Here is the link to datetime.datetime.timestamp's documentation.

answered Jan 25 '17 at 17:03

daragua

1,133
6
8

I am using python 2+. but thanx a lot. I learn this new thing for python 3. – roy Jan 25 '17 at 17:05
1

Right! I noticed that a bit late, well, here it stays for later reference. – daragua Jan 25 '17 at 17:09

score 0 · Answer 3 · edited Jun 20 '20 at 09:12

Please read the docs for calendar.timegm (emphasis mine):

calendar.timegm(tuple)

An unrelated but handy function that takes a time tuple such as returned by the gmtime() function in the time module, and returns the corresponding Unix timestamp value, assuming an epoch of 1970, and the POSIX encoding.

The UNIX timestamp is defined to be a non-negative integer. Well, Wikipedia says that it can be floating-point, but anyways, UNIX systems normally represent it with a variable of C type time_t, which is whole non-negative. An integer, because it's meant to represent the number of seconds passed since the beginning of the UNIX epoch.

So, it clearly cannot represent milliseconds because it's defined to be a whole number.

time data conversion missing microseconds in gm time python

3 Answers3