Skip to main content
Solved

datediff function resulted in an overflow

  • February 28, 2023
  • 3 replies
  • 283 views

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

Forum|alt.badge.img+3
  • 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


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