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
Answer from EdChum on Stack Overflow
🌐
Pandas
pandas.pydata.org › docs › reference › api › pandas.to_datetime.html
pandas.to_datetime — pandas 3.0.2 documentation
The object to convert to a datetime. If a DataFrame is provided, the method expects minimally the following columns: "year", "month", "day". The column “year” must be specified in 4-digit format. errors{‘raise’, ‘coerce’}, default ‘raise’ · If 'raise', then invalid parsing ...
🌐
GeeksforGeeks
geeksforgeeks.org › python › how-to-convert-datetime-to-date-in-pandas
How to Convert Datetime to Date in Pandas ? - GeeksforGeeks
July 23, 2025 - DateTime is a collection of dates ... as Time. In this article, we are going to discuss converting DateTime to date in pandas. For that, we will extract the only date from DateTime using the Pandas Python module....
🌐
Pandas
pandas.pydata.org › docs › reference › api › pandas.Series.dt.date.html
pandas.Series.dt.date — pandas 3.0.1 documentation
Returns numpy array of python datetime.date objects. Namely, the date part of Timestamps without time and timezone information. ... Returns numpy array of datetime.time objects. The time part of the Timestamps. ... The year of the datetime. ... The month as January=1, December=12. ... The day of the datetime. ... >>> 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
🌐
InfluxData
influxdata.com › home › pandas datetime: when and how to use it | influxdata
Pandas DateTime: When and How to Use It | InfluxData
December 6, 2023 - In this blog post, we'll dive into the world of Pandas DateTime, exploring what it is, how it works, and the various ways you can use it.
🌐
Medium
medium.com › @whyamit404 › converting-pandas-timestamp-to-datetime-0390728d0a2c
Converting Pandas Timestamp to Datetime | by whyamit404 | Medium
February 26, 2025 - For single values and native Python datetime objects, go with to_pydatetime(). Q2: How to convert a whole column of timestamps to datetime? You might be wondering: “How can I convert an entire column of timestamps in my DataFrame?” · Here’s ...
Find elsewhere
🌐
Reddit
reddit.com › r/learnpython › pandas convert object to datetime
r/learnpython on Reddit: Pandas convert Object to Datetime
October 27, 2018 -

Good morning, I have been struggling with converting a pandas dataframe column from Object type to Datetime. The dates in the column are in the following format:

Thursday, Mar 9

I have tried several variations of the following code:

df['date']=pd.to_datetime(df['date'], format='%A, %b %d')

Every different variation of the above code returns an error saying

the errortime data 'Thursday, Mar 9' does not match format '%A,%b %d'

I feel like this should be simple but I'm banging my head against the wall trying to get over this. Thanks in advance for any help

🌐
GeeksforGeeks
geeksforgeeks.org › pandas › change-string-to-date-in-pandas-dataframe
Change String To Date In Pandas Dataframe - GeeksforGeeks
July 23, 2025 - This is the most commonly used method to convert string dates into datetime64[ns] format. It automatically detects and converts various date formats, making it efficient for handling standard date strings.
🌐
Programiz
programiz.com › python-programming › pandas › datetime
Pandas DateTime (With Examples)
We use the to_datetime() function to convert strings to the DateTime object. Let's look at an example. import pandas as pd # create a datetime string date_string = '2001-12-24 12:38' print("String:", date_string)
🌐
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 - To convert a datetime column to a date column in a Pandas DataFrame, you can use the dt accessor along with the date attribute. For example, the pd.to_datetime function is used to convert the ‘datetime_column’ to a datetime data type.
🌐
Statology
statology.org › home › how to convert datetime to date in pandas
How to Convert Datetime to Date in Pandas
September 1, 2020 - A simple explanation of how to convert datetime to date in pandas, including an example.
🌐
GeeksforGeeks
geeksforgeeks.org › python-pandas-to_datetime
Python | Pandas.to_datetime() - GeeksforGeeks
December 4, 2023 - When a CSV file is imported and ... rather than a Date Time object. Pandas to_datetime() method helps to convert string Date time into Python Date time object....
🌐
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 - As usual, when working with Python, the indexes start at 0. Noteworthy here is that we also used the index_col parameter and set this to the first column (0) in the datafile. If we, on the other hand, would have had the dates in the first column (i.e., in the .csv file), we can set the dates as index: df = pd.read_csv('convert_pandas_column_to_datetime.csv', index_col=0, parse_dates=True) df.info()Code language: Python (python)
🌐
Data to Fish
datatofish.com › string-to-datetime-pandas
How to Convert Strings to Datetime in a pandas DataFrame
df['timestamp'] = pd.to_datetime(df['timestamp'], format='%Y-%m-%d %H:%M:%S') print(df.dtypes) ... That's it! You just converted a column of date strings to a datetime column.
🌐
Pandas
pandas.pydata.org › pandas-docs › version › 0.22 › generated › pandas.to_datetime.html
pandas.to_datetime — pandas 0.22.0 documentation
DatetimeIndex · TimedeltaIndex · PeriodIndex · Scalars · Window · GroupBy · Resampling · Style · General utility functions · Developer · Internals · Release Notes · Enter search terms or a module, class or function name. pandas.to_datetime(arg, errors='raise', dayfirst=False, yearfirst=False, utc=None, box=True, format=None, exact=True, unit=None, infer_datetime_format=False, origin='unix')[source]¶ ·
🌐
Vultr Docs
docs.vultr.com › python › third-party › pandas › to_datetime
Python Pandas to_datetime() - Convert to DateTime | Vultr Docs
December 9, 2024 - The to_datetime() function in pandas is a powerful and flexible tool for converting strings, lists, or Series to DateTime objects, facilitating the manipulation and analysis of time-series data.
🌐
Programiz
programiz.com › python-programming › pandas › methods › to_datetime
Pandas to_datetime()
The to_datetime() method is used to convert various types of date formats into a standardized datetime format. The to_datetime() method in Pandas is used to convert various types of date formats into a standardized datetime format.
🌐
PyImageSearch
pyimagesearch.com › home › blog › pandas to_datetime ( pd.to_datetime )
Pandas to_datetime ( pd.to_datetime ) - PyImageSearch
May 21, 2024 - In this comprehensive tutorial, we’ve explored the Pandas pd.to_datetime function, which is essential for converting various date and time strings into datetime objects in Python.