Use the to_datetime function, specifying a format to match your data.
df['Mycol'] = pd.to_datetime(df['Mycol'], format='%d%b%Y:%H:%M:%S.%f')
Pandas
pandas.pydata.org › docs › reference › api › pandas.to_datetime.html
pandas.to_datetime — pandas 3.0.1 documentation - PyData |
Convert argument to datetime. This function converts a scalar, array-like, Series or DataFrame/dict-like to a pandas datetime object.
GeeksforGeeks
geeksforgeeks.org › python › how-to-convert-datetime-to-date-in-pandas
How to Convert Datetime to Date in Pandas ? - GeeksforGeeks
July 23, 2025 - In this example, a DataFrame with a 'DateTime' column containing datetime values is created. Using Pandas, the code converts the 'DateTime' column to a new 'Date' column containing only the date part, and the updated DataFrame is displayed.
Videos
02:54
Python: Convert datetime to date using pandas - YouTube
05:37
Convert to DateTime - YouTube
07:02
Object, String, Text, to Date & DateTime in Pandas and Python - ...
05:37
Convert to DateTime
Pandas To DateTime | pd.to_datetime()
07:39
How to Convert a Column to Datetime in Pandas - YouTube
Top answer 1 of 7
844
Use the to_datetime function, specifying a format to match your data.
df['Mycol'] = pd.to_datetime(df['Mycol'], format='%d%b%Y:%H:%M:%S.%f')
2 of 7
119
If you have more than one column to be converted you can do the following:
df[["col1", "col2", "col3"]] = df[["col1", "col2", "col3"]].apply(pd.to_datetime)
Top answer 1 of 7
741
The easiest way is to use to_datetime:
df['col'] = pd.to_datetime(df['col'])
It also offers a dayfirst argument for European times (but beware this isn't strict).
Here it is in action:
In [11]: pd.to_datetime(pd.Series(['05/23/2005']))
Out[11]:
0 2005-05-23 00:00:00
dtype: datetime64[ns]
You can pass a specific format:
In [12]: pd.to_datetime(pd.Series(['05/23/2005']), format="%m/%d/%Y")
Out[12]:
0 2005-05-23
dtype: datetime64[ns]
2 of 7
79
If your date column is a string of the format '2017-01-01' you can use pandas astype to convert it to datetime.
df['date'] = df['date'].astype('datetime64[ns]')
or use datetime64[D] if you want Day precision and not nanoseconds
print(type(df['date'].iloc[0]))
yields
<class 'pandas._libs.tslib.Timestamp'>
the same as when you use pandas.to_datetime
You can try it with other formats then '%Y-%m-%d' but at least this works.
Spark By {Examples}
sparkbyexamples.com › home › pandas › pandas convert datetime to date column
Pandas Convert Datetime to Date Column - Spark By {Examples}
November 8, 2024 - You can convert a datetime column to a date without creating a new column by directly overwriting the existing datetime column. For example, the original ‘datetime_column’ is directly overwritten with the date values using df['datetime_column'] ...
TutorialsPoint
tutorialspoint.com › how-to-convert-datetime-to-date-in-pandas
How to Convert Datetime to Date in Pandas?
August 3, 2023 - Next, we create a sample DataFrame with datetime values in the 'datetime' column. To perform datetime operations, we need to convert the 'datetime' column to the datetime type using the pd.to_datetime() function.
Top answer 1 of 13
646
Since version 0.15.0 this can now be easily done using .dt to access just the date component:
df['just_date'] = df['dates'].dt.date
The above returns datetime.date, so object dtype. If you want to keep the dtype as datetime64 then you can just normalize:
df['normalised_date'] = df['dates'].dt.normalize()
This sets the time component to midnight, i.e. 00:00:00, but the display shows just the date value.
pandas.Series.dt
2 of 13
95
Simple Solution:
df['date_only'] = df['date_time_column'].dt.date
Statology
statology.org › home › how to convert datetime to date in pandas
How to Convert Datetime to Date in Pandas
September 1, 2020 - Often you may want to convert a datetime to a date in pandas. Fortunately this is easy to do using the .dt.date function, which takes on the following syntax: df['date_column'] = pd.to_datetime(df['datetime_column']).dt.date · For example, suppose we have the following pandas DataFrame:
Pandas
pandas.pydata.org › pandas-docs › stable › reference › api › pandas.to_datetime.html
pandas.to_datetime — pandas 3.0.1 documentation
Convert argument to datetime. This function converts a scalar, array-like, Series or DataFrame/dict-like to a pandas datetime object.
Favtutor
favtutor.com › articles › pandas-datetime-to-date
Convert Datetime to Date Column in Pandas (with code)
January 4, 2024 - Here are some easy methods to convert datetime to date column in Pandas using date method and normalize function.
Data to Fish
datatofish.com › string-to-datetime-pandas
How to Convert Strings to Datetime in a pandas DataFrame
import pandas as pd data = ... 2 2021-03-15 19:50:40 timestamp object dtype: object · Just as before, you can then convert it like this: df['timestamp'] = pd.to_datetime(df['timestamp'], format='%Y-%m-%d %H:%M:%S') print(df.dtypes) ......
GeeksforGeeks
geeksforgeeks.org › convert-the-column-type-from-string-to-datetime-format-in-pandas-dataframe
Convert column type from string to datetime format in Pandas dataframe - GeeksforGeeks
Using astype('datetime64[ns]')** successfully converts the Date column to the **datetime64[ns]` format. ... Pandas is an open-source Python Library that is made mainly for working with relational or labelled data both easily and intuitively.
Published December 30, 2020
GeeksforGeeks
geeksforgeeks.org › python › how-to-convert-datetime-to-date-in-python
How to convert datetime to date in Python - GeeksforGeeks
July 23, 2025 - The date value and the DateTime value are both displayed in the output using the print command. The DateTime values are first added to a column of a Pandas DataFrame. The DateTime value is then converted to a date value using the dt.date() function.
Delft Stack
delftstack.com › home › howto › python pandas › how to convert dataframe column to datetime in pandas
How to Convert Pandas Column to Datetime | Delft Stack
February 2, 2024 - Pandas pd.to_datetime() function converts the given argument to datetime. ... The format parameter in the Pandas to_datetime function specifies the pattern of the datetime string.
Seaborn Line Plots
marsja.se › home › programming › python › pandas convert column to datetime – object/string, integer, csv & excel
Pandas Convert Column to datetime - object/string, integer, CSV & Excel
November 20, 2023 - We have a DataFrame named df containing ... seamlessly convert these columns to the desired datetime format, we apply the pd.to_datetime() function to the specified columns....
Vultr Docs
docs.vultr.com › python › third-party › pandas › to_datetime
Python Pandas to_datetime() - Convert to DateTime | Vultr Docs
December 9, 2024 - Start with a simple date string. Use to_datetime() to convert it to a DateTime object.
Medium
deallen7.medium.com › managing-date-datetime-and-timestamp-in-python-pandas-cc9d285302ab
Managing Date, Datetime, and Timestamp in Python/Pandas | by David Allen | Medium
July 26, 2022 - # using timedelta on a datetime from datetime import timedeltatoday = pd.to_datetime('today') last_week = today + timedelta(days=-7)# this will return a timestamp ... Documentation and tutorials on Python, Pandas, Jupyter Notebook, and Data Analysis.
Pandas
pandas.pydata.org › docs › reference › api › pandas.Series.dt.date.html
pandas.Series.dt.date — pandas 3.0.1 documentation - PyData |
>>> s = pd.Series(["1/1/2020 10:00:00+00:00", "2/1/2020 11:00:00+00:00"]) >>> s = pd.to_datetime(s) >>> s 0 2020-01-01 10:00:00+00:00 1 2020-02-01 11:00:00+00:00 dtype: datetime64[us, UTC] >>> s.dt.date 0 2020-01-01 1 2020-02-01 dtype: object
Saturn Cloud
saturncloud.io › blog › converting-a-column-to-date-format-in-pandas-dataframe
Converting a Column to Date Format in Pandas Dataframe | Saturn Cloud Blog
October 27, 2023 - Next, we use the to_datetime() function to convert the “date” column to date format. The to_datetime() function returns a Pandas datetime object, which we assign back to the “date” column of the dataframe.