Skip to main content
To homepage To homepage
Solved

SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

  • November 22, 2021
  • 1 reply
  • 497 views
R
Explorer

I try to connect to an oracle database in TimeXtende and i get the error "SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM". 

I have no blanks in the datetime-field
I have no date before 10-2-2010 and I have no dates after 22-11-2021

I have several several datetime-fields like 5-3-2020 00:00:00

Could the time being the problem ? How can i stil import alle records in TX ? 

 

 

Best answer by Syed Yousuf

Hi Roland,

This guide Connect to MySQL using ADO.Net

mentions the same issue and a workaround using DateTime2 and

Using the Override Data Type feature

    1 reply

    S
    Contributor
    Forum|alt.badge.img+3
    • Syed Yousuf
    • Contributor
    • Answer
    • November 22, 2021

    Hi Roland,

    This guide Connect to MySQL using ADO.Net

    mentions the same issue and a workaround using DateTime2 and

    Using the Override Data Type feature

    Niels Jonker
    Terms and ConditionsCookie settingsAccessibility statement