how to import date time data from excel into django model（mysql）?

Question

I have a question about django admin import file. my excel data include DateTime data like 2010/10/10 13:10 , i want to import it into mysql by django admin. I used DateTimeField in models. What is the time data format? how to do this?

check out : docs.djangoproject.com/en/1.11/ref/settings/#datetime-format — navyad
– navyad, Commented Nov 20, 2017 at 8:43

NanNanX · Accepted Answer · 2017-11-20 12:27:49Z

0

that function is natural from python, just stablish the format of incoming string date and do the following

https://stackoverflow.com/a/24228410/2946222

or

https://stackoverflow.com/a/8636887/2946222

answered Nov 20, 2017 at 12:27

NanNanX

11 bronze badge

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

Comments

JLOGAN · Accepted Answer · 2017-11-21 03:14:49Z

0

[https://django-import-export.readthedocs.io/en/latest/api_widgets.html#import_export.widgets.DateTimeWidget][1]

This can work, just use settings.DATETIME_INPUT_FORMATS

answered Nov 21, 2017 at 3:14

JLOGAN

4311 bronze badges

Collectives™ on Stack Overflow

how to import date time data from excel into django model（mysql）?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related