New to Dataiku DSS? Try out our NEW Quick Start Programs today and get onboarded on the product in just one hour! Let's go

Parsing Dates in the Second SQL Prepare Recipe Hands On

tgb417
Neuron
Neuron
Parsing Dates in the Second SQL Prepare Recipe Hands On

I'm finding the parsing of dates in the Second SQL Hands-On Prepare Recipe to be a bit odd.

https://academy.dataiku.com/dataiku-dss-sql-1/500835

In the video I see that the Date format(s) selected was 

yyyy/HH/mm   (Year/Hour in day/Minute in hour)

In my mind birthdays are typically:

yyyy/MM/dd (Year/Month in year/Day in month)

And in fact, when I choose the format that makes sense to me there are four records that do not parse for Leap year problems.

[11:21:16] [WARN] [dku.shaker.date] - SHAKER_BAD_DATE: Failed to parse '1965/2/29' using format 'yyyy/MM/dd': Cannot parse "1965/2/29": Value 29 for dayOfMonth must be in the range [1,28]
[11:21:16] [WARN] [dku.shaker.date] - SHAKER_BAD_DATE: Failed to parse '1965/2/29' using format 'yyyy/MM/dd': Cannot parse "1965/2/29": Value 29 for dayOfMonth must be in the range [1,28]
[11:21:16] [WARN] [dku.shaker.date] - SHAKER_BAD_DATE: Failed to parse '1993/2/29' using format 'yyyy/MM/dd': Cannot parse "1993/2/29": Value 29 for dayOfMonth must be in the range [1,28]
[11:21:16] [WARN] [dku.shaker.date] - SHAKER_BAD_DATE: Failed to parse '1993/2/29' using format 'yyyy/MM/dd': Cannot parse "1993/2/29": Value 29 for dayOfMonth must be in the range [1,28]
[11:21:16] [WARN] [dku.shaker.date] - SHAKER_BAD_DATE: Failed to parse '1993/2/29' using format 'yyyy/MM/dd': Cannot parse "1993/2/29": Value 29 for dayOfMonth must be in the range [1,28]

Is this a thing?  Are there places in the world that show birthdates as:

(Year/Hour in day/Day in Month)?

Below is a frame from the video:

DateTime Format.jpg

 

--Tom
2 Replies
Alex_Reutter
Dataiker
Dataiker

Hi!  That's an error in the video and it should be yyyy/MM/dd.  Thanks for catching this.

0 Kudos
tgb417
Neuron
Neuron
Author

Thanks.

--Tom
0 Kudos