CODEWITHSUNDEEP
pythonstringdatejulian-date
alice
alice

Reputation: 325

how to convert a string into julian date in python

My table a field is format like "8192009", type is string. I need to convert it into julian date. Like how many days in a year. I have tried 

>>> from datetime import datetime
>>> date_object=datetime.strptime("8192009","%b%d%Y")

it gives me ValueError: time data '8192009' does not match format '%b%d%Y'

Upvotes: 1

Views: 571

Answers (1)

ergonaut
ergonaut

Reputation: 7057

try this:

>>> date_object=datetime.strptime("Aug192009","%b%d%Y")
>>> date_object
datetime.datetime(2009, 8, 19, 0, 0)
>>>

or this:

>>> date_object=datetime.strptime("8192009","%m%d%Y")
>>> date_object
datetime.datetime(2009, 8, 19, 0, 0)
>>>

Upvotes: 2

Related Questions