Convert timestamp to rfc 3339 in Python

Question

I am trying to convert the timestamp 1452454659 to its rfc3339 equivalent.

I am getting the output as:

2016-01-11T01:07:39+05:30

When I pass this to influxdb it returns a time of:

2016-01-10T19:37:39Z

while I actually want the time in influxdb to be:

2016-01-11T01:07:39

I have even tried to pass only 2016-01-11T01:07:39, leaving out +5:30, but then it gives me no result.

What mistake am I making?

I do not want to use now() as my timestamp is already there as a string, and that is why i do not want to use "now()" — Vishal Puliani, Jan 10 '16 at 18:29
the added part: *"I am getting the output as 2016-01-11T01:07:39+05:30, when i pass this to influxdb it returns a time of: 2016-01-10T19:37:39Z from influxdb while i actually want the time in influxdb to be 2016-01-11T01:07:39."* is unrelated to your question *"convert timestamp to rfc 3339"*. Ask a new question about your issues with influxdb specifically. — jfs, Jan 11 '16 at 03:56
All timestamps in InfluxDB are UTC. There are no time zones nor time zone support. — beckettsean, Jan 15 '16 at 00:51

score 3 · Answer 1 · answered Jan 10 '16 at 09:36

if your timestamp is from utc format, the following example may help you : (just replace the variable 'd' with your own timestamp)

import datetime
d = datetime.datetime.utcnow()
print d.isoformat("T") + "Z"


--> 2016-01-10T09:33:33.865129Z

score 3 · Answer 2 · answered Jan 10 '16 at 10:28

3

>>> print datetime.datetime.utcnow().strftime("%Y-%m-%dT%H:%M:%S.%f")[:-4]+"Z"
2016-01-10T10:27:45.89Z

answered Jan 10 '16 at 10:28

Rolf of Saxony

score 2 · Answer 3 · answered Jan 10 '16 at 09:40

2

There is a specialized python package for this:

answered Jan 10 '16 at 09:40

Radek Hofman

3 Answers3