python django: convert the postgresql timestamp to datetime

Question

I have a postgresql table with a timestamp field, among other fields.

How can I convert this timestamp field to a standard datetime python object and get the date like this: "Apr 23"

I know how to do it in the django template (with the 'date' template tag), I need to do in views.py so I can create an array with these dates and pass it to the django template.

Well, if you are using a Django model, and you are using a models.DateTimeField(), Django's ORM will take care of the details of translating from the database format to a Python datetime object. Once you have it as a Python datetime object, you can print it out in a variety of ways. — Brian Neal
– Brian Neal, Commented Mar 24, 2011 at 21:27

MattoTodd · Accepted Answer · 2011-03-24 22:59:46Z

3

Something like this:

TIME_FORMAT = "%b %d"
f_str = obj.date.strftime(TIME_FORMAT)

or

TIME_FORMAT = "%b %d"
arr = [d.strftime(TIME_FORMAT) for d in dates]

strftime formatting

edited Mar 24, 2011 at 22:59

answered Mar 24, 2011 at 22:54

MattoTodd

15.3k16 gold badges64 silver badges77 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

python django: convert the postgresql timestamp to datetime

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related