Format datetime column using pandas

Question

I need to delete dot and digits after dot in pandas datetime colums:

0   2020-01-05 21:58:15.030099
1   2020-01-09 09:15:01.286888

I write this code, but the result is the same (digits after dot):

ret.reg_dt = pd.to_datetime(ret.reg_dt, format='%Y-%m-%d %H:%M:%S')

How can I delete it?

jezrael · Accepted Answer · 2020-10-20 08:31:32Z

1

You can use Series.dt.floor by seconds:

ret.reg_dt = ret.reg_dt.dt.floor('S')
print (ret)
               reg_dt
0 2020-01-05 21:58:15
1 2020-01-09 09:15:01

answered Oct 20, 2020 at 8:31

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1