OutOfBoundsDatetime: cannot convert input -11644473600.0 with the unit 's'

Asked Feb 23 '21 at 15:40

Active Feb 23 '21 at 17:39

Viewed 614 times

I am trying to turn that number from a dataframe into a datetime, the column time['date'] looks like the following:

i tried the following:

df1["st_mtime"]=pd.to_datetime(df1["st_mtime"],unit="s")

so i am getting below error:

OutOfBoundsDatetime: cannot convert input -11644473600.0 with the unit 's'

I want it to be changed to dd/mm/yyyy HH:MM:SS.

edited Feb 23 '21 at 17:39

James Z

asked Feb 23 '21 at 15:40

It is in negative sign. – Pygirl Feb 23 '21 at 15:47
if these are seconds since the epoch (Unix time), this would be around the year 1600. However, pandas Timestamp can only go back to `Timestamp('1677-09-21 00:12:43.145225')`. – FObersteiner Feb 23 '21 at 16:18
[This](https://stackoverflow.com/questions/6161776/convert-windows-filetime-to-second-in-unix-linux) might help. – forgetso Feb 23 '21 at 16:25
@Pygirl yes its negative time which i am unable to understand how to transform – somya p chaturvedi Feb 24 '21 at 07:47
@MrFuppeswhat do you suggest , should be done? – somya p chaturvedi Feb 24 '21 at 07:47

0 Answers0