Convert date format to insert into mysql db

Question

I have pandas column row['date'] which contains date in format 11/05/2015. I am trying to insert it into mysql db but having problems due to incorrect format of date field data. It has to be converted into 2015-11-05 in order to be inserted. Without storing the new value in variable how can I convert the date into required format?

Current format: 11/05/2015
Required format: 2015-11-05

Possible duplicate of Convert String In Python to insert into MySQL DB date column date — Eli Sadoff
– Eli Sadoff, Commented Nov 7, 2016 at 15:49

Mat · Accepted Answer · 2016-11-07 15:52:20Z

2

Is the current format mm/dd/yyyy? If so

from datetime import datetime
row['date'] = datetime.strptime(row['date'], '%m/%d/%Y').strftime('%Y-%m-%d')

answered Nov 7, 2016 at 15:52

Mat

1,42311 silver badges17 bronze badges

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

2 Comments

r0xette Over a year ago

I didn't want to further clutter the code so here is what I did and this is ready by my sql query using .format. datetime.strptime(row['date'], '%m/%d/%Y').strftime('%Y-%m-%d')

Mat Over a year ago

You might even be able to send the datetime object to the database depending on how your MySQL adaptor works.

SparkAndShine · Accepted Answer · 2016-11-07 16:15:12Z

0

Use dateutil.parser,

This module offers a generic date/time string parser which is able to parse most known formats to represent a date and/or time.

Here is a MWE.

from dateutil.parser import parse

current_date = '11/05/2015'
required_date = parse(current_date).strftime('%Y-%m-%d')

PS: to explicitly distinguish between DM and MD, pass the argument dayfirst=True/False to parse, i.e. dayfirst=True represents DM and dayfirst=False represents MD.

edited Nov 7, 2016 at 16:15

answered Nov 7, 2016 at 15:55

SparkAndShine

18.2k27 gold badges100 silver badges140 bronze badges

2 Comments

Mat Over a year ago

Explicit is better than implicit. I'd say its better to be explicit about what format you are converting from. 11/05/2015 could be either dd/mm/yyyy or mm/dd/yyyy.

SparkAndShine Over a year ago

@Mat, thx, then add the argument dayfirst=False (the default value) to parse.

Scott Hunter · Accepted Answer · 2016-11-07 15:55:12Z

-1

This should do the job, w/o needing datetime:

"{2}-{0}-{1}".format(*(original_date.split("/")))

answered Nov 7, 2016 at 15:55

Scott Hunter

50k12 gold badges65 silver badges107 bronze badges

2 Comments

Mat Over a year ago

I think you're better off using datetime rather than mangling the string. Reading this line as is the intent is not clear.

Scott Hunter Over a year ago

Not disagreeing; just providing an option.

Collectives™ on Stack Overflow

Convert date format to insert into mysql db

3 Answers 3

2 Comments

2 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related