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.1 documentation - PyData |
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 ...
🌐
Pandas
pandas.pydata.org › pandas-docs › stable › reference › api › pandas.to_datetime.html
pandas.to_datetime — pandas 3.0.1 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 ...
🌐
Pandas
pandas.pydata.org › docs › user_guide › timeseries.html
Time series / date functionality — pandas 3.0.1 documentation
DatetimeIndex can be converted to an array of Python native datetime.datetime objects using the to_pydatetime method. pandas has a simple, powerful, and efficient functionality for performing resampling operations during frequency conversion (e.g., converting secondly data into 5-minutely data).
🌐
Pandas
pandas.pydata.org › docs › reference › api › pandas.Series.dt.date.html
pandas.Series.dt.date — pandas 3.0.1 documentation - PyData |
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
🌐
GeeksforGeeks
geeksforgeeks.org › pandas › python-pandas-to_datetime
Pandas.to_datetime()-Python - GeeksforGeeks
June 24, 2025 - pandas.to_datetime() converts argument(s) to datetime. This function is essential for working with date and time data, especially when parsing strings or timestamps into Python's datetime64 format used in Pandas.
🌐
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 › pandas-docs › version › 1.5 › reference › api › pandas.to_datetime.html
pandas.to_datetime — pandas 1.5.3 documentation
The object to convert to a datetime. If a DataFrame is provided, the method expects minimally the following columns: "year", "month", "day". errors{‘ignore’, ‘raise’, ‘coerce’}, default ‘raise’ · If 'raise', then invalid parsing will raise an exception.
Find elsewhere
🌐
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.
🌐
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]¶ ·
🌐
Pandas
pandas.pydata.org › pandas-docs › stable › reference › api › pandas.Series.dt.date.html
pandas.Series.dt.date — pandas 2.2.3 documentation - PyData |
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
🌐
Educative
educative.io › answers › what-is-the-pandastodatetime-method
What is the pandas.to_datetime() method?
The pandas.to_datetime() method in Python converts data into datetime objects.
🌐
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.
🌐
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.
🌐
Pandas
pandas.pydata.org › pandas-docs › version › 0.20 › generated › pandas.to_datetime.html
pandas.to_datetime — pandas 0.20.3 documentation
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]¶
🌐
Favtutor
favtutor.com › articles › pandas-datetime-to-date
Convert Datetime to Date Column in Pandas (with code)
January 4, 2024 - Another built-in Python function that we can use for this conversion is the .normalize() method. It is particularly useful when you need to normalize the data by extracting the date from DateTime. Let’s see how it works: import pandas as pd from datetime import datetime # Create a custom sample dataset data = {'Timestamp': [datetime(2023, 1, 15, 8, 30), datetime(2023, 1, 16, 12, 45), datetime(2023, 1, 17, 10, 0), datetime(2023, 1, 18, 14, 15)]} # Create a DataFrame from the sample dataset df = pd.DataFrame(data) # Display the original DataFrame print("Original DataFrame:") print(df) # Convert Datetime object to date string using .normalize() df['Date'] = df['Timestamp'].dt.normalize() # Display the DataFrame with the new 'Date' column print("\nDataFrame with Date String:") print(df[['Date']])
🌐
Codecademy
codecademy.com › docs › python:pandas › built-in functions › .to_datetime()
Python:Pandas | Built-in Functions | .to_datetime() | Codecademy
June 26, 2025 - The .to_datetime() function in Pandas transforms various date and time representations into standardized pandas datetime objects.
🌐
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)
🌐
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 ...