Django check if variable contains datetime and format

Question

How do I check if a variable contains a datetime and the format it to just include the date, hour, minutes and seconds. Not milliseconds.

The issue I'm having is that the variable isn't in datetime format as it can either contain text or a date time.

return isinstance(new_value, datetime.datetime)

Therefore running the command above returns false.

If new_value contains 2016-05-24 09:26:51.754000+00:00 how do I format it to look like this : 2016-05-24 09:26:51

I want to format the variable into itself and display it in a table. — JohnTaylor, Jun 06 '16 at 08:52
You can refer this answer: Maybe, http://stackoverflow.com/questions/37648868/getting-monday-june-5-2016-instead-of-june-5-2016-using-datetimefield#comment62777942_37648868 — Thinh Phan, Jun 06 '16 at 09:10

score 0 · Answer 1 · answered Jun 06 '16 at 09:40

At first you need to convert date string to the datetime object, in this way you can check it with 'isinstance()', but I want to suggest better solution, as I think :), because at the Python 2.7, so still popular, we have issue with timezone offset ( %z ) when convert date string to datetime object, so here is my solution without 'strptime' :

from dateutil import parser
date = '2016-05-24 09:26:51.754000+00:00'
try:
    # something if format correct
    parsed_date = parser.parse(date)
    # formatting
    print parsed_date.strftime("%Y-%m-%d %H:%M:%S")
except ValueError:
    # something if format incorrect
    print 'Wrong date format'

Sure, please don't forget to write :

$pip install python-dateutil

Django check if variable contains datetime and format

1 Answers1