Parsing Dates in the Second SQL Prepare Recipe Hands On

tgb417

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:

Alex_Reutter

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

tgb417

Thanks.