Hi team!
I am contacting you because I am trying to transfer data from MariaDB to ODX and I received the following error
failed with error:
System.FormatException: The DateTime represented by the string is not supported in calendar
Any suggestion to solve it?
Regards
Ignacio
Best answer by ignacio
View original
add more information
System.Globalization.GregorianCalendar.
Since i don't have screenshots i'm guessing here. But it seems that the calendar in your first datawarehouse layer is a datetime. but it's getting in as a string from your odx/business unit. Did you try the different types of datatype override? it might be that you need a datetime2 to convert a string into a valid date datatype.
+5
Convert it to datetime2, it is likely out of the allowed range for a normal datetime.
Hi team,
I used Manage Query Tables, and I had to use Mariadb’s functions TO_DAYS and FROM_DATE.
This way I solved the problem.
Thanks
Ignacio
+5
Hi
Do you know how the date in MariaDB was structured before coming in to TX?
I don't have access to read the data before TX
+5
Don’t bother then, if it works it works.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
