Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to convert Julian date to standard date?

I have a string as Julian date like "16152" meaning 152'nd day of 2016 or "15234" meaning 234'th day of 2015.

How can I convert these Julian dates to format like 20/05/2016 using Python 3 standard library?

I can get the year 2016 like this: date = 20 + julian[0:1], where julian is the string containing the Julian date, but how can I calculate the rest according to 1th of January?

like image 957
abidinberkay Avatar asked Jun 10 '16 08:06

abidinberkay


2 Answers

The .strptime() method supports the day of year format:

>>> import datetime
>>>
>>> datetime.datetime.strptime('16234', '%y%j').date()
datetime.date(2016, 8, 21)

And then you can use strftime() to reformat the date

>>> date = datetime.date(2016, 8, 21)
>>> date.strftime('%d/%m/%Y')
'21/08/2016'
like image 54
Brendan Abel Avatar answered Sep 30 '22 11:09

Brendan Abel


Well, first, create a datetime object (from the module datetime)

from datetime import datetime
from datetime import timedelta
julian = ... # Your julian datetime
date = datetime.strptime("1/1/" + jul[:2], "%m/%d/%y") 
# Just initializing the start date, which will be January 1st in the year of the Julian date (2 first chars)

Now add the days from the start date:

daysToAdd = int(julian[2:]) # Taking the days and converting to int
date += timedelta(days = daysToAdd - 1)

Now, you can just print it as is:

print(str(date))

Or you can use strftime() function.

print(date.strftime("%d/%m/%y"))

Read more about strftime format string here

like image 38
Yotam Salmon Avatar answered Sep 30 '22 11:09

Yotam Salmon