Why Dataiku added a minute
Marek_Zak
Registered Posts: 4 ✭✭✭
Description:
44586 is an example number from my data set
Expression in dataiku recipe: inc(asDate('1900-01-01','yyyy-mm-dd'),44586-2,'d')
result after executing recipe from dataiku level: '2022-01-25 01:01:00.000 +0100'
sql version of an expression: TO_DATE('1900-01-01','yyyy-mm-dd') + (interval '1 day' * (44586::int8 -2))
result after executing recipe from dataiku level: '2022-01-25 01:00:00.000 +0100'
DB engine is postgresql
Why is 1 minute was added when using formula language???
Best Answer
-
Ignacio_Toledo Dataiku DSS Core Designer, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 415 NeuronHi @Marek_Zak
,This should solve the problem:
inc(asDate('1900-01-01','yyyy-MM-dd'),44586-2,'d')
Note that MM must be in capital letters to detect a month, else it will take the parsed value as a minute (mm)
Hope this helps!