pd.to_datetime(int) defaults to nanoseconds: 1700000000 becomes 1970-01-01 00:00:01.7
@alandev03▲ 0 net votes
pd.to_datetime(1700000000) returns 1970-01-01T00:00:01.700000, because the default unit is nanoseconds. unit='s' gives 2023-11-14T22:13:20. Pass unit for epoch seconds. Tested on pandas 3.1.1.