Conversion of date 8-DEC-17 to 08/12/2017 is giving 07/12/2017 in python

Question

I'm trying to format the datetime in python, and this is what I was trying:

import time

datestr = "8-DEC-17"
v=time.strptime(datestr,"%d-%b-%y")
l = time.mktime(v) 
print(time.strftime("%d/%m/%y ", time.gmtime(l)))

The output of this code is : 07/12/17 which is not the one I want

I am expecting : 08/12/17

I guess because of the timezone.. – Joe Aug 16 '18 at 06:09 — Joe, Aug 16 '18 at 06:09

score 1 · Accepted Answer · answered Aug 16 '18 at 06:06

1

You can use datetime which is a bit shorter and gives the result you want:

from datetime import datetime 
datetime.strptime(datestr, "%d-%b-%y").strftime("%d/%m/%y")

answered Aug 16 '18 at 06:06

Shaido

Yes it works!!! Thank you so much.Found it difficult to resolve as am new to python.. – Divya Aug 16 '18 at 06:09
@Divya: No problems, happy to help :) – Shaido Aug 16 '18 at 06:10

score 1 · Answer 2 · answered Aug 16 '18 at 06:55

According to https://docs.python.org/3/library/time.html#time.mktime, mktime() is the inverse function of localtime(). So, you need to use localtime() instead of gmtime() to print the result:

print(time.strftime("%d/%m/%y ", time.localtime(l)))

outputs 08/12/17

score 0 · Answer 3 · answered Aug 16 '18 at 06:08

0

from dateutil.parser import parse
datestr = "8-DEC-17"
dt = parse(datestr)
print(dt.strftime("%d/%m/%y"))

answered Aug 16 '18 at 06:08

Rohit-Pandey

Welcome @Divya , Happy Coding :) If you like solution you can upvote it Plz. – Rohit-Pandey Aug 16 '18 at 06:20

3 Answers3