Why Dataiku added a minute

Marek_Zak
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
    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 Neuron
    Answer ✓

    Hi @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!

Setup Info
    Tags
      Help me…