Advanced Designer Learning Path is now live! Read More

Parsing Dates in the Second SQL Prepare Recipe Hands On

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

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

0 Kudos
Neuron
Neuron
Author

Thanks.

--Tom
0 Kudos