PYTHON

apply format to pandas datetime column

formatted_df = df["Date"].dt.strftime("%m/%d/%y")

format date field in pandas

df['date'] = pd.to_datetime(df["date"].dt.strftime('%Y-%m'))

format datetime python pandas

df['DOB']=pd.to_datetime(df['DOB'].astype(str), format='%m/%d/%Y')

format datetime python pandas

df.style.format({"DOB": lambda t: t.strftime("%m/%d/%Y")})

format datetime python pandas

df.style.format({"DOB": lambda t: t.strftime("%d-%m-%Y")})

format datetime python pandas

import pandas as pd

df = pd.DataFrame({'DOB': {0: '26/1/2016 ', 1: '26/1/2016 '})
print(df.dtypes)

df['DOB1'] = df['DOB'].dt.strftime('%m/%d/%Y')
print(df.dtypes)

df['DOB1'] = pd.to_datetime(df['DOB1'])
print(df.dtypes)