Date format detection, Dataiku versionning

Kouegou Kamen

Hello, it seems I am going through a Dataiku versionning issue:

I've many project developed on an old verions 9.0.1 where all the dates were automatically detected in a " yyyy-MM-dd HH:mm:ss.S " format and then, we were ultimately obliged to parse the dates in a prepare recipe to have a dataiku well parsed date format.

But now on the current version I updated, 11.1.4, the same dates are recognized in a different format

yyyy-MM-dd HH:mm:ss and thus, all my prepare recipe to parse the old dates are crashing !!!!

Is there a way to fix that issue ?

I hope not to be obliged to modify all the project one by one in order to delete the parsing recipe ?

I wonder if I could'nt configure the new version to still recognize by default all the dates in the old format " yyyy-MM-dd HH:mm:ss.S " as in the previous version.

I am Working with "Oracle databases"

Sarina

Hi @Boris
,

I wonder if you can open a support ticket with a job diagnostic for one of the failing jobs. If you still have job logs from prior to DSS 11, if you can attach a job diagnostic for one of the DSS 9.0.1 runs so that we can compare the two, that would be the most useful!

Thank you,
Sarina

Kouegou Kamen

Hi,
Thanks for going through my question,

but the problem is not a recipe that doesn't work, but the fact that the date format changed for oracle databases from yyyy-mm-dd hh:mm:ss.S to yyyy-mm-dd hh:mm:ss in the new version.

Is there a way to change the default date format recognition ?

Thanks a lot.