What is the largest datetime in python?

Asked Jul 05 '20 at 19:16

Active Jul 05 '20 at 19:56

Viewed 540 times

I am new to pandas and trying to read a date from excel. For validation, when I use 'pd.to_datetime' to compare against another datetime object, for date 9999-12-31, I am getting an exception: 'OutofBoundsDateTime', whereas I believe this should still be a valid MAXDATE as per standards. Here is a sample code where I am facing such issue:

import pandas as pd
df = pd.DataFrame(["9999-12-31"])
pd.to_datetime(df[0])

Executing the above code results into OutofBoundsDateTime exception. Whereas if I choose any other date, there is no such exception.

edited Jul 05 '20 at 19:18

Balaji Ambresh

4,977
2
5
17

asked Jul 05 '20 at 19:16

Vitthal Kulkarni

Related : https://stackoverflow.com/q/35415247/12416453 – Ch3steR Jul 05 '20 at 19:20
I'm wondering if there's something like `np.iinfo` / `np.finfo` for `datetime`. – Ch3steR Jul 05 '20 at 19:24
You can use `datetime.datetime.max` ---> `datetime.datetime(9999, 12, 31, 23, 59, 59, 999999)` but don't if this holds true with `np.datetime64` – Ch3steR Jul 05 '20 at 19:27
Considier asking the pandas team at github. Your ask is reasonable. – Balaji Ambresh Jul 05 '20 at 19:43
Thanks. Have raised to pandas team at github – Vitthal Kulkarni Jul 06 '20 at 16:37

What is the largest datetime in python?

0 Answers0