Conversion of date formats

Question

I wanted to convert a list containing dates in the format:

01 MAR 2020

Into this format :

2020-03-01 (YYYY-MM-DD)

using python. Is there a way to do this??

What is the "main issue" about MAR being capitalized? What happened when you tried `"%d %b %Y"`? — Brad Solomon, Aug 04 '20 at 12:02

niko · Accepted Answer · 2020-08-04T12:09:52.193

4

Yes using datetime

from datetime import datetime

# Python object
datetime.strptime("01 MAR 2020", "%d %b %Y")
# datetime.datetime(2020, 3, 1, 0, 0)

# Converted Format
datetime.strptime("01 MAR 2020", "%d %b %Y").strftime('%F')
# 2020-03-01'

PS The locale used might cause problems when dealing with non-numeric months. See here for help on the topic.

edited Aug 04 '20 at 12:09

answered Aug 04 '20 at 12:01

niko

5,253
1
12
32

I get a "ValueError: time data '01 MAR 2020' does not match format '&d %b %Y'" from your first code excerpt. – Cribber Aug 04 '20 at 12:03
1

@Cribber That might help https://stackoverflow.com/questions/985505/locale-date-formatting-in-python – niko Aug 04 '20 at 12:08
ah, the code worked when I set locale to us_US. Good to know! – Cribber Aug 04 '20 at 12:10

Conversion of date formats

1 Answers1