Ready for Dataiku 10? Try out the Crash Course on new features!GET STARTED

Why Dataiku added a minute

Solved!
Marek_Zak
Level 2
Why Dataiku added a minute

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???

0 Kudos
1 Solution
Ignacio_Toledo

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!

View solution in original post

0 Kudos
1 Reply
Ignacio_Toledo

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!

0 Kudos

Setup info

?
A banner prompting to get Dataiku DSS