Login

Parse datetime model field to string

Author:
jzelez
Posted:
July 3, 2010
Language:
Python
Version:
1.2
Score:
0 (after 0 ratings)

Checks the type of the field (date / time / date-time) and returns corresponding value as a string.

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
def convertDatetimeToString(o):
	DATE_FORMAT = "%Y-%m-%d" 
	TIME_FORMAT = "%H:%M:%S"

	if isinstance(o, datetime.date):
	    return o.strftime(DATE_FORMAT)
	elif isinstance(o, datetime.time):
	    return o.strftime(TIME_FORMAT)
	elif isinstance(o, datetime.datetime):
	    return o.strftime("%s %s" % (DATE_FORMAT, TIME_FORMAT))

More like this

  1. Template tag - list punctuation for a list of items by shapiromatron 2 months, 2 weeks ago
  2. JSONRequestMiddleware adds a .json() method to your HttpRequests by cdcarter 2 months, 3 weeks ago
  3. Serializer factory with Django Rest Framework by julio 9 months, 2 weeks ago
  4. Image compression before saving the new model / work with JPG, PNG by Schleidens 10 months, 1 week ago
  5. Help text hyperlinks by sa2812 11 months ago

Comments

bolso103 (on November 3, 2011):

Hello,

I am using the function, but I do not know why isinstance(o, datetime.time) is returning false, when it should be true. My model has a DateTimeField attribute:

-----------------------------------------------------

class Measure (models.Model):

    power = models.IntegerField()               
date = models.DateTimeField('measure date')     
machine = models.ForeignKey(Machine)

def __unicode__(self):
    return self.machine.name

----------------------------------------------------

On the shell:

date=Measure.objects.get(id=4).date

print date

2011-11-01 01:18:27

conv = convertDatetimeToString(Measure.objects.get(id=4).date)

print conv

2011-11-01

#

hobs (on January 17, 2013):

You put .date rather than .datetime after the field which converts the datetime.datetime object (a DateTimeField in your db) into a datetime.date object. A date object doesn't contain time information and it doesn't inherit the datetime class, so the isinstance doesn't match datetime.datetime. Try doing type(obj) whenever you want to know what type an object is.

#

Please login first before commenting.