Velvet Star Monitor

Standout celebrity highlights with iconic style.

news

Django string to date format

Writer Emily Wong

I want to convert my string date to django date format. I tried a method. but did not work.

date = datetime.datetime.strptime(request.POST.get('date'),"Y-mm-dd").date()

I got this error.

time data '2014-04-07' does not match format 'Y-mm-dd'

what 's wrong in my code.

4 Answers

It should be %Y-%m-%d:

>>> s = "2014-04-07"
>>> datetime.datetime.strptime(s, "%Y-%m-%d").date()
datetime.date(2014, 4, 7)

According to the documentation:

  • %Y stands for a year with century as a decimal number
  • %m - month as a zero-padded decimal number
  • %d - day of the month as a zero-padded decimal number

Hope that helps.

2

It might be convenient to use django's dateparse in this case.

from django.utils.dateparse import parse_date
date_str = request.POST.get('date')
date = parse_date(date_str)
2

django.utils.dateparse.parse_date function will return None if given date not in %Y-%m-%d format

I have not found a function in django source code to parse string by DATE_INPUT_FORMATS. So I wrote a custom helper function for that and I have added to here for help others.

from datetime import datetime
from django.utils.formats import get_format
def parse_date(date_str): """Parse date from string by DATE_INPUT_FORMATS of current language""" for item in get_format('DATE_INPUT_FORMATS'): try: return datetime.strptime(date_str, item).date() except (ValueError, TypeError): continue return None
3

It might be convenient to use Django's dateparse's parse_datetime in this case. you don't have to explicitly apply the data time format if that is dynamic.

from django.utils.dateparse import parse_datetime
date = parse_datetime(datetime_str)

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy