You’re offline. This is a read only version of the page.
30
Hello,
we provide data via API interface. In our case some date fields are NULL. These NULL values are represented as 0001-01-01 in the API. When trying to write the data to a SQL database, we get an error because the min. date is 1753-01-01.
How do you handle such problems ?
With NULL values are actually meant 0D values
You need to manage this issue at the code level only the Null values stored in our SQL Database as 1900-01-01 or 1753-01-01 etc what I do is Extract the Year from the Date and compare it with IF Year>2000 then only assigned the Date to my Table Field else I skip the API value to be modified in my Date type Field to ignore this kind of default values.
mark my answer as verified if this was helpful
Share
Report
All responses (
Answers (
