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
  • 456 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

View original
    Did this topic help you find an answer to your question?

    1 reply

    S
    Contributor
    Forum|alt.badge.img+3
    • Syed Yousuf
    • Contributor
    • 82 replies
    • 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
    1 person likes this
    • Niels Jonker
      Niels Jonker

    Reply


    Most helpful members this week

    Terms and ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings