Parse date string and change format

Question

I have a date string with the format  Mon Feb 15 2010    I want to change the format to  15 02 2010    How can I do this

User · Answer

You can install the dateutil library   Its parse function can figure out what format a string is in without having to specify the format like you do with datetime strptime   from dateutil parser import parse dt   parse  Mon Feb 15 2010   print dt    datetime datetime 2010  2  15  0  0  print dt strftime   d  m  Y      15 02 2010

User · Answer

Just for the sake of completion  when parsing a date using strptime   and the date contains the name of a day  month  etc  be aware that you have to account for the locale   It s mentioned as a footnote in the docs as well    As an example   import locale print locale getlocale      gt  gt    nl BE    ISO8859-1    from datetime import datetime datetime strptime  6-Mar-2016     d- b- Y   strftime   Y- m- d     gt  gt  ValueError  time data  6-Mar-2016  does not match format   d- b- Y   locale setlocale locale LC ALL   en US   datetime strptime  6-Mar-2016     d- b- Y   strftime   Y- m- d     gt  gt   2016-03-06

User · Answer

use datetime library  http   docs python org library datetime html look up 9 1 7   especiall strptime   strftime    Behavior   examples  http   pleac sourceforge net pleac python datesandtimes html

User · Answer

You may achieve this using pandas as well   import pandas as pd  pd to datetime  Mon Feb 15 2010   format   a  b  d  Y   strftime   d  m  Y     Output    15 02 2010    You may apply pandas approach for different datatypes as   import pandas as pd import numpy as np  def reformat date date string  old format  new format       return pd to datetime date string  format old format  errors  ignore   strftime new format   date string    Mon Feb 15 2010  date list     Mon Feb 15 2010    Wed Feb 17 2010   date array   np array date list  date series   pd Series date list   old format     a  b  d  Y  new format     d  m  Y   print reformat date date string  old format  new format   print reformat date date list  old format  new format  values  print reformat date date array  old format  new format  values  print date series apply lambda x  reformat date x  old format  new format   values    Output   15 02 2010   15 02 2010   17 02 2010     15 02 2010   17 02 2010     15 02 2010   17 02 2010

User · Answer

datetime module could help you with that   datetime datetime strptime date string  format1  strftime format2    For the specific example you could do    gt  gt  gt  datetime datetime strptime  Mon Feb 15 2010     a  b  d  Y   strftime   d  m  Y    15 02 2010   gt  gt  gt

User · Answer

convert string to datetime object  from datetime import datetime s    2016-03-26T09 25 55 000Z  f     Y- m- dT H  M  S  fZ  out   datetime strptime s  f  print out  output  2016-03-26 09 25 55

User · Answer

gt  gt  gt  from date  Mon Feb 15 2010   gt  gt  gt  import time                  gt  gt  gt  conv time strptime from date   a  b  d  Y    gt  gt  gt  time strftime   d  m  Y  conv   15 02 2010

User · Answer

codeling and  user1767754   The following two lines will work  I saw no one posted the complete solution for the example problem that was asked  Hopefully this is enough explanation   import datetime  x   datetime datetime strptime  Mon Feb 15 2010     a  b  d  Y   strftime   d  m  Y   print x    Output   15 02 2010

User · Answer

As this question comes often  here is the simple explanation   datetime or time module has two important functions     strftime - creates a string representation of date or time from a datetime or time object  strptime - creates a datetime or time object from a string    In both cases  we need a formating string  It is the representation that tells how the date or time is formatted in your string   Now lets assume we have a date object    gt  gt  gt  from datetime import datetime  gt  gt  gt  d   datetime 2010  2  15   gt  gt  gt  d datetime datetime 2010  2  15  0  0    If we want to create a string from this date in the format  Mon Feb 15 2010    gt  gt  gt  s   d strftime   a  b  d  y    gt  gt  gt  print s Mon Feb 15 10   Lets assume we want to convert this s again to a datetime object    gt  gt  gt  new date   datetime strptime s    a  b  d  y    gt  gt  gt  print new date 2010-02-15 00 00 00   Refer This document all formatting directives regarding datetime

[python] Parse date string and change format

Examples related to python

Examples related to datetime

Examples related to datetime-parsing