Skip to main content
To homepage To homepage
Solved

datediff function resulted in an overflow

  • February 28, 2023
  • 3 replies
  • 283 views
S
Contributor

Hi,

I am using the ODX server to get data from the SQL server database.

After executing the transfer task, I am getting the below error.

Any idea how to solve this?

“System.Data.SqlClient.SqlException (0x80131904): The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large. Try to use datediff with a less precise datepart.System.Data.SqlClient.SqlException (0x80131904): The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large. Try to use datediff with a less precise datepart.”

Best answer by Christian Hauggaard

Hi @sguntupalli, another alternative is to use data type override feature to bring in the date column as text and then later on convert it back to a date

 

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

3 replies

S
Contributor
Forum|alt.badge.img+3
  • Syed Yousuf
  • Contributor
  • 82 replies
  • February 28, 2023

Which version of ODX and SQL Provider are you using ?

Have you defined incremental load on a date type column ?

Can you use a Query Table with an explicit SQL statement to extract rows from this table ?

Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

Hi @sguntupalli, another alternative is to use data type override feature to bring in the date column as text and then later on convert it back to a date

 

Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

Hi @sguntupalli did you manage to resolve the error? If so can you please help us by selecting and marking a best answer

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