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 : https://docs.djangoproject.com/en/1.11/ref/settings/#datetime-format — navyad, Nov 20 '17 at 08:43

score 0 · Answer 1 · answered Nov 20 '17 at 12:27

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 '17 at 12:27

NanNanX

1
1

score 0 · Answer 2 · answered Nov 21 '17 at 03:14

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 '17 at 03:14

JLOGAN

43
11

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

2 Answers2