DateRange Timestamp conversion on windows fails with timestamps close to EPOCH

[bdemirtas]

Expected Behavior

When you use DateRange with starting date before 1970 (EPOCH) it raise OSError.
OSError: [Errno 22] Invalid argument
Linking the bug ticket from Python
https://bugs.python.org/issue37527

Current Behavior

Currently it works as intended for any non Windows OS . The work around is to provide the datetime with a timezone utc.

Steps to Reproduce (for bugs)

This code will fail and raise OSError on windows.

testDataSpec = (
    dg.DataGenerator( spark, name="test_data_set1", rows=1000 partitions=4)
    .withColumn(
        "purchase_date",
        "date",
        data_range=dg.DateRange("1910-10-01 00:00:00", "1950-10-06 11:55:00", "days=3"),
        random=True,
    )
)

Context

Your Environment

• dbldatagen version used:
• Databricks Runtime version:
• Cloud environment used: