BUG: out-of-bounds datetime parsing

[jreback]

In [2]: pd.__version__
Out[2]: '0.19.0+695.g2e64614'

suprisingly [2] and [3] return the same as [1] on linux-64 (meaning they don't raise).
This is from macosx. This is the correct behavior (raising).

In [1]: pd.Timestamp('01-01-01')
Out[1]: Timestamp('2001-01-01 00:00:00')

In [2]: pd.Timestamp('001-01-01')
OutOfBoundsDatetime: Out of bounds nanosecond timestamp: 1-01-01 00:00:00

In [3]: pd.Timestamp('0001-01-01')
OutOfBoundsDatetime: Out of bounds nanosecond timestamp: 1-01-01 00:00:00

[jorisvandenbossche]

I get the correct behaviour (so raising) on linux-64 (Ubuntu 16.04, python 2 and 3)

In [51]: pd.show_versions()

INSTALLED VERSIONS
------------------
commit: None
python: 3.5.2.final.0
python-bits: 64
OS: Linux
OS-release: 4.4.0-70-generic
machine: x86_64
processor: x86_64
byteorder: little
LC_ALL: None
LANG: en_US.UTF-8
LOCALE: en_US.UTF-8

[jreback]

very weird. The reason I noticed this was #15828 failed on Travis with this & it failed on a local linux-64 vm. (on 2.7)

macosx is on 3.6. It possible this is a 2/3 issue.

[jorisvandenbossche]

I tried both python 3.5 and 2.7, and both worked correctly ..

[jbrockmendel]

@jreback in 0.23.3 I get OutOfBoundsDatetime in both [2] and [3] on both OSX[py27,py37] and Ubuntu16.04[py27,py35]. Do you still get the original behavior?

[mzamyatina]

Hi, I get that error too on Ubuntu 14.04, Python 3.6.8 Anaconda custom (64-bit):

In [1]: import pandas                                                                                                                                              

In [2]: pandas.__version__                                                                                                                                         
Out[2]: '0.24.1'

In [3]: pandas.Timestamp('0001-01-01')                                                                                                                             
---------------------------------------------------------------------------
OutOfBoundsDatetime                       Traceback (most recent call last)
<ipython-input-3-fbea3956a1c7> in <module>
----> 1 pandas.Timestamp('0001-01-01')
pandas/_libs/tslibs/timestamps.pyx in pandas._libs.tslibs.timestamps.Timestamp.__new__()
pandas/_libs/tslibs/conversion.pyx in pandas._libs.tslibs.conversion.convert_to_tsobject()
pandas/_libs/tslibs/conversion.pyx in pandas._libs.tslibs.conversion.convert_str_to_tsobject()
pandas/_libs/tslibs/conversion.pyx in pandas._libs.tslibs.conversion.convert_str_to_tsobject()
pandas/_libs/tslibs/np_datetime.pyx in pandas._libs.tslibs.np_datetime.check_dts_bounds()
OutOfBoundsDatetime: Out of bounds nanosecond timestamp: 1-01-01 00:00:00

Any updates on a fix?

[jbrockmendel]

@justmeteomary4 the behavior in [3] you posted is correct; we expect that to raise because pandas Timestamp doesn't support dates before 1677-09-21. If you need to represent an earlier date, use pd.Period.

[mroeschke]

This should be fully correct now and could use a test